Use 1 Form To Show Old Data And New Data

[Richard_Marx]

I have a form that is displaying previous data that is already input for review (non-editable), and I need a way (preferably the same form) to input new data.

For the newly input data, I have a button that has a label displayed that states "Add New Data" --> and they will input an employee id then on the

empID_Change()

event I am running a procedure to query my database and auto-fill several of the fields. Now the question I have at hand is, how can I differentiate between a newly added record (where data should auto-populate) and an old record (where data should not populate)?

What recommends would the more advanced users have to accomplish this?

[Bulzie]

Check for data on one of the auto-populated fields, it if is null, then auto-populate the record, if there is data then don't? Make sure it is a field that will always have data.

On the design, I would suggest displaying the records on a form(lock the fields so it cannot be edited). Then at the top put you Add New button and when clicked, pop up a Form to enter a nre record. When it opens you can pre-fill the data as needed. Once they save the data and close that pop up Form, (OnClose event of the popup) Requery your main Form so the new record now shows.

[ranman256]

If the form is a master/child form,
the sub form would show old data.
then click a button, or a tab, to change the sub form to New records.

[Richard_Marx]

Check for data on one of the auto-populated fields, it if is null, then auto-populate the record, if there is data then don't? Make sure it is a field that will always have data.

Address will never be null, so implement a check such as

If Me![Add1] <> "" Then
    GetDataFromDB
End If

Afterthought --> If the text box is bound field, will I be able to write the query result to the text box?

[Richard_Marx]

If the form is a master/child form,
the sub form would show old data.
then click a button, or a tab, to change the sub form to New records.

It is currently one form so I assume that would be a master form. I do not have a parent/child or master/child set-up. Would that be the best way to go to achieve what I am after?

[Bulzie]

I think it would be
If Me![Add1] = "" Then
GetDataFromDB
End If

You want to add the data if there is no value in that field right?

[Richard_Marx]

I think it would be

If Me![Add1] = "" Then
    GetDataFromDB
End If

You want to add the data if there is no value in that field right?

Thank you for catching my rookie mistake there!