Liz, what Geof is trying to get is an idea about your table structure.
When designing and building a database more than 60% of your time may
be in correctly getting the table structure structured. Things like
Forms can only become solutions once the underlying data is properly
organised
So far, we don't have nearly enough information about the structure of
your tables to provide a Forms solution. Can you help by giving us
this information
- What tables do you have the information in?
- What is the RecordSource (Menu->View->Properties->Data tab->) of
your form?
Brett
Yes Geoff, I have a table sorted into alphabetical order using the Postcodes
as its key column which has 5 columns. What I am now trying to do is design a
form for a user to input one or more of those postcodes and get the details
from the columns called X & Y
Liz
Cheers,
Brett