Have to close out form then reopen for new data to appear in combobox

[NotaryEtc]

Hello all,



You all have been very helpful, so hopefully you can help me with this.

I have a button on one of my forms that opens to my customer form, and here I can add new customers. Problem is, once I save the record....The only way I can see the new customer listed in the combobox is by closing the form and reopening it. Is there anything that can be done to fix this?

[Bob Fitz]

You could requery the combo box in its Got Focus event. Something like:
Me.ActiveControl.Requery

[Ruegen]

You could requery the combo box in its Got Focus event. Something like:
Me.ActiveControl.Requery

The combo box has a row source which can be requiried. Before you close the form, run code that lets you requery the other form if it is open.

I use

If CurrentProject.AllForms("YourFormName").IsLoaded Then
Forms!YourFormName!ComboBoxControl.Requery
End If

[NotaryEtc]

Thanks but when it comes to codes, I have no experience! Here are the names of my forms/tables....Maybe you can give me a code to copy and paste then tell me where to put it?

The name of the form the button is located on is called MotorVehicleJF. This form is a based on a junction table, and is being used as a subform. The combo box located on this form this holding the customer first and last name (and I guess customerid as well)

When you click the "Add New Customer" button from the MotorVehicleJF......the customer form, called CustomerF will open up. Here I can add a new customer.

Now I need this new customer to automatically show up in the combo box on the MotorVehicleJF without me having to close and reopen the form.

[orange]

Can you show us the code relate to the Click event?

Go to form design view. Put the cursor on the Add New Customer button, right click, show properties; event Procedure.

Please copy the code and paste it in your post.

[Ruegen]

The second form CustomerF has properties

Some of these properties are events, there is a close event for CustomerF

When you add the code into the event, when you close the form, it fires off the event.

The code I provided below works like this


If something is true/false then

do this

end if



That's a basic IF statement.

So using that if statement I put the method CurrentProject.AllForms().isloaded

This particular method (or function) gives a true or false.

The reason I did this first, if I fire off code and the form isn't open then it crashes, so that is why I use the IF statement.

then to requery use


Forms!YourFormName!ComboBoxControl.Requery


and finally it it with end if

now when the form closes, you get the combo box requiered.

Simply replace YourFormName with the name of the form the control is on as well as ComboBoxControl with the name of your control (which is MotorVehicleJF according to you)

[NotaryEtc]

this is what it says on the line in the property sheet....[Embedded Macro]

When I click on the 3 little dots, it opens a new window that says

Open Form

Form Name CustomerF

View Form

Filter Name

Where Condition

Data Mode

Window Mode Normal

Then what appears to be a combobox with the words "add new action" inside...

[Ruegen]

this is what it says on the line in the property sheet....[Embedded Macro]

When I click on the 3 little dots, it opens a new window that says

Open Form

Form Name CustomerF

View Form

Filter Name

Where Condition

Data Mode

Window Mode Normal

Then what appears to be a combobox with the words "add new action" inside...

That's a macro, that is not using VBA. I think it's third option form the popup when you hit the event property, if you see the window of the macro again go back a step and see again.

[Ruegen]

This might help

http://www.youtube.com/watch?v=G9pqmd2PSYk