access-database-training - showing info another form

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » access-database-training - Showing info from another form

access-database-training - Showing info from another form

resolvedResolved · Low Priority · Version Standard

Marie has attended:
Access Intermediate course

Showing info from another form

I'm rebuilding a database and want to replicate something it does in another form. In a nutshell, the form has a lookup combo box which contains details from another table, so when you enter a piece of equipment you can choose from the combo box what kind of equipment it is. The bit that's puzzling me is that once you've chosen what you want from the pop-up in the combo box, it displays info from the line you chose in extra fields on the form. How is it doing this?? In design view, the fields that shows this info contain:

=[ComboItemKey].[Column](4)

and

=([ComboItemKey].[Column](1))+(" ")+([ComboItemKey].[Column](2))

I want to replicate this elsewhere in other forms but can't work out what this bit of code is doing/pointing at - can anyone help me out or suggest anything?

RE: Showing info from another form

Hi Marie

In principal, it looks like one lookup off another, however, unless I see the whole proces, it might not be. Anyway.
There may be some additonal code running this process. From what it looks like the two peices of data you send are pure lookup sources. The second one is joining the contents of two fields (Column 1 and 2) from the ComboItemkey object, wheras the first piece of data only brings through column 4.

Lookups can be a bit more complex that just pointing to the field. If you would like to to look at it a bit more closely, sned your Database to richard AT microsofttraining DOT net and I can take a look.

Regards

Richard

RE: Showing info from another form

Thanks Richard - dug a bit deeper into the lookups and figured it out. Very grateful!


 

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips


Server loaded in 0.09 secs.