Unable to enter field into Forms

G

Gandhi_bob

Hi Guy's,

I'm quite a nOOb at Access but i have created a form with details form
several tables, i then created another table to handle data from the
form but i am unable to insert the field from the new table into the
form, does anyone know how to enter the field as another control? I've
been trying for days now lol.

I appreciate any help given.

Robert Parker,

P.S if anyone knows where is can access Office 2003 cheat sheets for
free plz advise.
 
G

Guest

A form can have only one record source. If you are using multiple tables,
you will have to create a query to join the tables and use the query as the
record source. In many cases, this will not work. You will need to use a
sub form to handle the additional table provided the tables are related.
 

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

Similar Threads

Expression in forms 5
OnClick on Combo Box opens a New Form 0
Unable to enter more than 125 characters in text field. 2
Auto-update a field based on input from previous field 0
DMax on existing record to increment serialized # fails 1
Access Daily Entry with multiple entries per field 0
Using Enter Key to move from field to field 2
Field List Box 6

Top