How do i design a form for:

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to design a form in Access 2003 which the user can input several post
codes and then gets two columns of data returned with the original postcode
for each one entered. Can anyone help?
Input : L20 4UT
Answer L20 4UT column x column y

Liz
 
Liz,
Have you thought of what your table design(s) will be?
That should come first.
Geof.
 
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
 
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
Click to expand...

Cheers,
Brett
 
Back
Top