G
Guest
Hi,
I'm designing a "site information" database and I'm hoping someone can help
me with the following questions/issues I've come up against, please ?
I've created a form based on a table to display site information on a
one-at-a-time basis. I want to be able to search and display the information
by 3 unique fields, ie: name, number and ID. So, the idea is: you open the
form, you know which of our 300 sites you want to see the info for and you
have the choice of displaying that info by choosing a value from one of 3
combo boxes (ie: you may only know the ID, not the name or number, so you go
to the ID field and you hit the arrow to display the list, then you choose
which one you're after and the other fields in the form update to display
that ID's information).
I've currently got the form working with 1 combo box, which updates the rest
of the form after choosing a value from the list, but I'm stuck when trying
to create the other 2 for search and display as well.
Any ideas would be much appreciated !
I'm designing a "site information" database and I'm hoping someone can help
me with the following questions/issues I've come up against, please ?
I've created a form based on a table to display site information on a
one-at-a-time basis. I want to be able to search and display the information
by 3 unique fields, ie: name, number and ID. So, the idea is: you open the
form, you know which of our 300 sites you want to see the info for and you
have the choice of displaying that info by choosing a value from one of 3
combo boxes (ie: you may only know the ID, not the name or number, so you go
to the ID field and you hit the arrow to display the list, then you choose
which one you're after and the other fields in the form update to display
that ID's information).
I've currently got the form working with 1 combo box, which updates the rest
of the form after choosing a value from the list, but I'm stuck when trying
to create the other 2 for search and display as well.
Any ideas would be much appreciated !