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?

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

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