Forum home » Delegate support and help forum » Microsoft Access Training and help » access-database-training - Showing info from another form
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access-database-training - Showing info from another form
Resolved · Low Priority · Version Standard
Reply Thu 2 Aug 2007, 12:51Delegate Marie said...
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?
For upcoming training course dates see: Pricing & availability
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
Reply Mon 13 Aug 2007, 12:15Delegate Marie said...
RE: Showing info from another form
Thanks Richard - dug a bit deeper into the lookups and figured it out. Very grateful!
|