Data entry to 2 or more forms, help!!!!

[baobaowen]

Data entry to 2 or more tables with only 1 form, help!!!!

Hi,
I am an Access beginner.

I am trying to set up an inventory system.

I have 2 tables, one is called item list which contain item description and item part number.

second table is a "shipping and receiving log" which contain date, item description (linked to item list), unit in/out.

I am trying to create a form with data entry function. this form will be called "new item entry form".

what i am trying to do is whenever i have new item to enter in to the table, I will enter the name and the part number of the new item to the "item list" table, then enter an entry in the log to initialize an opening balance.

I am trying to achieve this using only 1 form, but i can't figure out how.

the relationship between this two table is item -> log (1 to many)

if i didn't make myself clear please let me know. I will try to explain more.

I am not sure if it made sense

 

[Dave Eyley]

On one form? Mmm...

Well, on the form you would have your input fields and a button to press to start a bit of code to save the data to the item list table.

Then requery a subform, also on the form, to add the log items.

Or, have the log details in a pop-up second form.

The trouble is the data will not normally be saved until you either close the form or do the code to save the data.

HTH Dave Eyley

 

[baobaowen]

can u give me a sample code to put in?
im pretty new to this

 

[baobaowen]

nevermind
i figured out