beginner

[leigh]

when i add a new field to the table it dosent show up in
the form where i enter the data?

 

[Allen Browne]

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.

 

[Guest]

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.




.

 

[Leigh]

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

 

[Allen Browne]

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.