Add "From" "to" data to table

[frikkie]

I am trying to create a trace database where i can record all stock received. My stock is only 1 item but with different unique serial numbers. So if i receive the stock from serial number 1 to 500 i want to capture the stock where each serial number is in its own row in the table. i want a form which a "from Number" and "to number" should pop up.I tried with queries, google code but cant find a method to do it.

[June7]

Don't really follow what you mean by 'pop up'.

If you want to 'capture' the stock then do data entry.

Really need more info about the process you are trying to program.

[frikkie]

I want to capture the serial numbers with input on a form. Meaning if i receive the stock i will open a form and then enter start serial number as "1" and end serial number as "500" This will the update a table in the database with 500 rows of data with the actual serial numbers as the data in this 500 rows.

[June7]

Requires VBA code writing records to table in a looping structure. Very simple example:

Sub btnSave_Click()
For x = Me.tbxStart To Me.tbxEnd
CurrentDb.Execute "INSERT INTO tablename(SerialNum, DateEnter) VALUES(" & x & ", Date())"
Next
End Sub

[CJ_London]

missed a bracket

VALUES(" & x & ", Date())"

[June7]

Thanks, Ajax. Corrected post.

[frikkie]

Thank You. I did the code and go tthe following error "Method or data member not found" this error is for "tbxStart" in the code. I am still new in VBA code. Thanks for the help

[June7]

Use whatever you named your textboxes.

[frikkie]

Hi. Sorry my mistake. Got it working now. Thanks very much.