Refreshing Forms (Via Embedded Button)

[jace2046]

I am have the worse time trying to create a form in access. I have my form set up so that when I input a procedure code it generates the fee from my vendors.

To update the form I have to tab off the search field, press enter, and then press "F5" for the results to take effect.

Is there a way that I embed a button in the form, that once it is pressed it will update the form.

I have tried using the wizard, and I get the following error message
"The command or action 'Refresh' isn't available now.

*You may be in a read-only database or an unconverted database from an early verison of Microsoft Office Access.

*The type of object the action applies to isn't currently selected or isn't in the active view.

Use only those commands and macro actions that are currently available for this database.

 

[jdraw]

What version of Access?
What is the purpose of the form?

What exactly do you mean by this

procedure code

.

Procedure and code have specific meanings in Access and vba.

Please describe what you are trying to accomplish, and let's see if others have suggestions/recommendations.

 

[jace2046]

I am using access 2007

My form is to be used to look up procedure codes that we use in our practice and the associated fees that go with that code.

When I referenced procedure code in my prior post it wasn't reffering to codes used in access, but as codes or id's we use in our business.

My form is set up with a text box that I am able to use our procedure code that we want to look up a fee for. Then I have several other text boxes that brings in the fees that are associated with the procedure code, but for those text boxes that show the fees to update, I have to tab out of the "procedure code" box and then press F5 for the form to update.

I just want to be able to embed a button within the form that I can press and the form will refesh and update with the fees that corrolate with the procedure code

 

[Dairy Farmer]

Private Sub RefreshButton_Click()
Me.Requery
End Sub

 

[vbaInet]

Is your form read-only? That is if you make and save a change to a field?

Why do you want to save the change when the user tabs out of ANY control? A record is commited when you move to another record or if you have a Save button on the form, that when clicked will save the record.