Setting the display of a combobox after a record is updated

[michaelb]

Good morning all,
I used a combobox to select a record in table A. The combobox displays the desired person's name in it and the form shows the correct information. After updating the record, I save it using a macro connected to a button. The macro also creates a new record. The first record in table A is blank so nothing appears in the combobox when the form is opened. How do I get the combobox to show the first record (blank) after the updated record is save and a new record is initiated.



You may have a completely different way of setting the display in a combobox after a record is saved. If so please let me know.

Thanks for you help

[orange]

What exactly is the rowsource of the combo?

[michaelb]

The rowsource for the combo is a query using table A. There are two fields in the query, the first is the IDnum and the second is a Fullname field.

[orange]

So you are saying that once you save a record in Table A, you no longer have a blank record in the combo. Is that correct? What exactly is available in the combo before and after you save a record?

You select an entry form the combo and then show details of that record is that correct?

[michaelb]

Before the record is saved in table A, the combobox displays the name use to select the record for updating. After the record is saved and the new record is created, the combobox still shows the last name selected through it. When the record is saved I want the combobox to show a blank:

Ex. John Doe is selected in the combobox. The information for John Doe is correctly in the form. The desired fields for the record are updated and the record is saved. When the new record is created, the combo still shows John Doe. I want the combobox to show a blank:

[orange]

When the new record is created, the combo still shows John Doe. I want the combobox to show a blank:

You said the record is updated. So where is the new record coming from?
John Doe was in combo and selected, fields in the record were updated, the record (same record) was saved.

New record??

If your combo row source is from a Table/query, why are you expecting a blank record?

Perhaps I'm missing something basic.

[michaelb]

The form was originally setup to add new records to a table (A). Later in the process I added a combo to the form to select records to update. There is a Add New Record button and a Save Record button on the form. If the user wants to add a record, they can use the Add button, if they want to update a record they can use the combobox. If they use the combobox and click the Save Record button, the last name selected in the combobox remains when the form is set for a new record. I thought a fix for this would be to save the updated record, set the GoToRecord action to First, which is the blank record. Then I hoped to refresh/repaint??? the combobox which would show a blank. When the new record was then created, the combo would be blank because the last record set was record 1/First. Please suggest another way to handle. I am still learning...

Thanks

[orange]

I would think that if you have a button labelled, ADD New Record, that you would not be selecting or even looking at the combo.

In the Click event of the Add New Record button, you would get a fresh empty record.

I think I'm still missing something with your set up.

If you add a new record, there is no old record (unless you're adding some other thing related to the person in the combo), so I wouldn't expect the cobo to be part of the Add New record.

[michaelb]

You are right. If a new record is added, there is no old record, but the combobox still displays the old information from the last selected name. The display of old information would be confusing to the users. Is there a way to blank the combobox so the last information is not displayed once the Save Record button on clicked?