beginner

L

leigh

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

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.
 
G

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.




.
 
L

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
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top