How do i design a form for:

G

Geof Wyght

Liz,
Have you thought of what your table design(s) will be?
That should come first.
Geof.
 
L

liz300385

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
 
B

Brett Collings [429338]

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
 
Top