I have a couple of comboboxes in a split form with the following Property Sheet setting: [Split Form Datasheet] set to “Allow Edits” and [Split form Printing] set to “Form Only” which allows for data entry to the source table. Unfortunately for me, it only allows me to add one record (row). As soon as I start typing in the second record it changes every column of the first record to what I am adding to record line two.

I have this IF statement:

I have a split form in datasheet view. The build-in search box at the bottom of the form is been used frequently form users. If the form’s

I have created a form within access that connects to an outside database, in this form I can create a case for the company I work, with all the required details. It also has some functions to automate some parts of the process, such as a button with function to open a word doc template from a certain folder and modify it with the details from the case. All good so far (I will show you code so you better understand what the form does)