How to use form to read and write values to master list

[JPS]

Hello,
I have a table called Master Records that contains the field "Title." This is the primary key that references several other tables in the DB.



I have a form to manually enter data for different tables- one of the fields in the form is "Title," and the data is pulled from the Master Records table. with this construct, I am limited to select only data that already exists in the Master Records table. I would like to use the form to add a new "Title" record to the Master Records table if it does not already exist in the table. I don't want to open a separate form to enter the new "Title." I envision something like how Excel works, where it tries to auto-fill the text if it matches previous records, but once you type something that does not match, it abandons the auto-fill and allows the user to complete a new record.

Is there a way to use a form to both read records from a table, but also to write a new record to the table if no match is found? Thanks!

[khalid]

Hi,
For this you have to write code on after update event of the masterfield on your form:

Which should check:
1- is the title is already used in the master table?
2- if yes, then don't do anything and use the master title.
3- else INSERT the new Master Title in the master table and give message (optional)
4- requery and refresh the combo box to use the new master title.

The above is rough idea on after update event on the field/combo on form. the code can be written after examining your master table fields.

Best Regards,

Khalid Afridi