Data Entry form help please

[jenny23]

Hello,
Thanks for reading my message.
I have one question about ms access forms:
I have 2 tables,
1. Student table has some fields like: stuID, stuAddress
2. REgister table has fields: stuID, stuAddress, claName, room

I want to create a form based on these tables, so that every time users submit this form, the data is stored in class table.
This is what I want to do:
I want to create a DATA ENTRY form that has all unique fieldnames from these tables, so that when user click on stuID drop-down list, student address appear on the stuAddress field. However, claName, room from register table don't show up, because I want them to enter by themself. So, when they submit, all the data will be stored in the register table.

Thanks.
--------------------------------------------------------------------------------

 

[Pat Hartman]

Create a query that joins the two tables. Select the columns you need from each table. Use the new query as the RecordSource for your form.

 

[jenny23]

Please help

In this case, it is not a data entry form. I mean, I know how to create a form that list all data from the table.
What I need is a data entry form that pull data from only one table and users must enter data to the form then submit, then the data is stored in a second table.

Can you please help?

Jenny.

 

[Pat Hartman]

Only the StuID needs to be stored in the register table. The others should not. If you don't want the student fields to be updatable on this form, set their locked properties to Yes.

 

[joeselch]

First off, follow Pat's advice about eliminating redundancy among tables.

Then, with your tables straightened out, create two forms:
one for your Student data and one for your Register data.
Use the Register form as a subform on your Student form.

 

[jenny23]

I am a newbie

Can you please teach me like a three years old baby?
I am really newbie in Access programming. Just 2 months learning ms Access.
Can you please provide steps by steps?

Thanks.

 

[joeselch]

Sorry jenny23 - I don't want to just abandon you, but I really don't have the time or wherewithal to teach you all you'll need to learn.

At this point, my best suggestion is to get a book; perhaps the Access Bible (as listed in the "Recommended Reading List" in the "General" forum).

 

[Pat Hartman]

Take a look at the northwinds.mdb that is installed with Access. You can also create a db from a template. There are also numerous sample db's that you can download from the Microsoft site.
Links to samples