Help writing code please!

[kieranharrison]

Hi Guys,



Hoping one of the experts can help me with this ... it's a bit of a curly one (for me anyways)

Basically, I am trying to make a form which has 4 fields on it that will populate the corresponding 4 fields in my received_files_table 'on click' using a command button. So the idea is to have the 4 fields in the form populated with data, then once the user selects on the command button the code runs and inputs the data into my received_files_table.

I have been able to get the command button to work with only one field in the form which goes to my example table (shown below in green), however, I need to get it so that all 4 fields (shown below in red) input data into the received_files_table via only 1 command button.

I have managed to get the dummy data into the example table using the below code, however, I need help to write a code which works using all 4 fields in the form.

As you can see the expression is - DoCmd.RunSQL "INSERT INTO example VALUES ([Combo26].Value)"

The field names I need the new code to use are - Received_Date ; IATA_Code ; Processing_ Month ; Airline

The corresponding table for these fields is called - received_files_table


​Thanks

[moke123]

Why not just use a bound form?

You should also declare Option Explicit at the top of every module. You can set it as the default in the VBE options. (check the box for "require variable declaration")

[kieranharrison]

Hi moke123,

Sorry I should've mentioned I am very new to access. Could you please explain how I could use a bound form?

Thanks,

[davegri]

Highlight the received_files_table in the navigation pane (like you show), then with the ribbon click Create, then click Form.
This will crate a form bound to the table. The form will show ALL the fields in the table. Any changes made to the form data will be updated automatically to the table.

[kieranharrison]

Thanks very much, davegri.

then how do I get the command button to work and enter all of the fields?

[kieranharrison]

Ahhh no worries, just realised you can use enter.

Thanks for your help guys... i'll get there haha.

[Micron]

realised you can use enter.

Maybe not a good idea for you to depend on this. For bound forms, anything you do to commit record creation or edit will do the same. If you created a form with a single record view and the form has record navigation controls at the bottom, change a field in a record. Then navigate to another record, then go back to the one you edited but didn't press enter on. Change was kept?