Refresh subform button or code?

[optionone]

Hi,

I have tried various suggestions on here as to refreshing a subform but they havent worked - i guess that is because my form is different and doesnt have any filters etc

I have a multi tabbed form and the particular tab in question has a button that imports new data to a table that is shown in the subform below it - ideally id like the information to show in the subform after the button is pressed - is there any simple solution to this?

Thanks

 

[Kryst51]

Add a requery in the button code for the subform, make sure you use the name of the subform control, not the subform itself. This would occur after the code that imports the other data.

Something Like:

Me.YourSubformControlNameHere.Requery

 

[optionone]

Add a requery in the button code for the subform, make sure you use the name of the subform control, not the subform itself. This would occur after the code that imports the other data.

Something Like:

Doesnt seem to work :/

Tried creating a button with the code on click but no joy

 

[Kryst51]

Can you post your code?

 

[optionone]

Can you post your code?

Dropped a button on to the form and set the on click to:

Me.updatetable.Requery
updatetable being the control on the form that imports data to the table shown by the subform

Clicking the button just brings up an error saying ms access cant find the macro 'me.'

 

[dbprogman]

Try using the actual form name instead of me. e.g. Form_frmYourForm.Requery

 

[Kryst51]

Dropped a button on to the form and set the on click to:

Me.updatetable.Requery
updatetable being the control on the form that imports data to the table shown by the subform

Clicking the button just brings up an error saying ms access cant find the macro 'me.'

Also, where did you put that? In the event property? If so, then you need to remove it.... Then click on the elipses that come up to the side of the "on click" event, double click on "code" then put your Me.updatetable.requery in the subprocedure that pops up