98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · 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
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 tip:Change The Default Font in Access 2003You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set. |