Connecting a form to a table

[Jon_y_Cumro]

Hi,

I'm new to Access (2000) and have a question which is probably pretty basic.

I've written a form and database which I want to use for basic data entry. When the user clicks "OK", I simply want to append the data in the form to corresponding fields in a table. I guess I'm missing something obvious here because what I'm trying to do seems as though it should be fundamental in Access.

Is it done through a query, code, a macro or a combination of these? Any help and advice would be appreciated.

Thanks in advance,
Jon

 

[Uncle Gizmo]

Well from the point of view that you are beginning with access you have gone about it the wrong way, what I would suggest is if you highlight the table and then invoke the form builder wizard it will build a form for you.

 

[maxmangion]

Also make sure that you build your form based on a query and not direct from a table.

 

[benlaird24]

Also make sure that you build your form based on a query and not direct from a table.

Why is that? What is wrong with basing your form off a table and having other fields referencing a query?