Form

[hami]

Hi,
I'm new in Access and facing a problem. Hope I’ll make myself clear.

I've a table "members" and I've created a form "member_form" based on this table (members).

1. I want to binde my form "member_form" with my table "member" so that the new data I store in form, automatically sotres in table. How can I do that

2. In form, I've fields "Member_ID" and "Member_Name". I want that when I type member_id in "Member_ID" field, the member name in "Member_Name" field come automatically. How can I do that???

Thanks in advance
Hami Bjorn

 

[ColinEssex]

No Data is ever stored in a form, a form is merely a window to the table.

Use a query as your recordset for the form (not the actual table) its much more flexible. Make the query and put it in the recordset property of the form.

There are various ways to achieve the second part - search these forums, there are many excellent examples

Col