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

 

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

 

[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).