beginner

  • Thread starter Thread starter leigh
  • Start date Start date
L

leigh

when i add a new field to the table it dosent show up in
the form where i enter the data?
 
1. Open your form in design view.

2. Open the Field List (View menu).

3. Drag the fields from the list into the Detail section of your form.
 
Thank you again.
-----Original Message-----
1. Open your form in design view.

2. Open the Field List (View menu).

3. Drag the fields from the list into the Detail section of your form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 
I have a number of tables by state i.e QLD NSW etc.
I am trying to creat a form where I can veiw all of the
data and add additional data.
can you help
thanks
 
Hi Leigh.

The best idea is going to be to combine them all into one table, with a
State field to indicate which state the record is for.

It is then every easy to create a query to pull the records for just one
state. You can even create a different form for each if you like (based on
the query).

But when you want to query the data across states, it will be *much* easier
than trying to work with a large, unweildy, read-only UNION query.
 
Back
Top