Take value from a form and write to a table as a new record

[themushroomking]

Hi folks! Kindly asking for some guidance because im stuck on something since forever. Im a novice Accesseroid



I have a MainForm with an ID. And a SubForm that searches in some excel files and returns the search in fields on the subform.
When the search results are correct, i want to add the "item" to the ItemsTable and link it to the MainForm ID.

I managed all that. I can do the search, return values in my form fields and save them in the table (relation) with the current MainForm ID.

My problem: I would like to keep adding items to the table, but it just overwrites the data in the table every time. (logically because its the same form field over and over).

What VBA do i need to add to my code to save the information as a NEW record, instead of overwriting???

Forms!inboundreturns.Form.Item.Value = Me.Item.Value

Thanks in advance guys!

[ranman256]

when you get to the last field on the form and press enter,
it goes to the 1st field on the next record. (if you did not alter form settings)

[themushroomking]

Hi Ranman, thanks for the swift reply!

In any case, sure i would say.

In my case i have a MainForm with an ID and i want to stay on that current ID and add items to it.
For a simple example: See it as a customer table, that has a relation to the sold items table.
Currently i am on the customer table and im adding items with a command button.
The code works fine, but i want it to put the item on a new row. (Currently it just overwrites)

So i am not making new records. But im adding items to the current record in a different table thats relational

[ranman256]

if the relation is set correctly, it should allow you to add many records.
if not, you are stuck on 1 record only.

[themushroomking]

if the relation is set correctly, it should allow you to add many records.
if not, you are stuck on 1 record only.

I should ofcourse, but its just overwriting what i have.
What about my code up there? Can i somehow just tell it to go to a new record first?

By adding something like AddNewRec or something like that??

[themushroomking]

UPDATE:

Looking at it, i see the problem:

The field on my form just gets updated every time. My code is wrong!

How do i take the value from my search form (my search results) and send them to the table with a command button?

Forms!inboundreturns.Form.Item.Value = Me.Item.Value

Im addressing the Form in this case. How can i say something along the lines of:

Table!inboundreturns_items.item.value = Me.item.value

[ssanfu]

In my case i have a MainForm with an ID and i want to stay on that current ID and add items to it.
For a simple example: See it as a customer table, that has a relation to the sold items table.
Currently i am on the customer table and im adding items with a command button.
The code works fine, but i want it to put the item on a new row. (Currently it just overwrites)

So i am not making new records. But im adding items to the current record in a different table thats relational

What you are saying is very confusing.

One way:
Using your example, you have a main form bound to the customer table (I always use a query). You want to add items to the sold items table for the selected customer. So you need a sub form, bound to the "sold items" table (should not use spaces in object names).
The main form/sub form would be linked by the Link Master field and the Link Child field.
No code necessary.

Another way:
A button that has code to execute an append query to the sold items table. Would have to/like to see your current button code.