Re Fresh Question!

[Bob]

When I open my DB It opens on frmMainMenu, Then I click a button to go to
frmCreateHoldingInvoices , from there I select a Invoice Name to go to a
List Box 1stModify(Unbound)on my frmMainMenu, Then if I click my button to
go back to frmMainMenu the Invoice does not show only if I close frmMainMenu
and re-open it I think I need a Me.Dirty somewhere....Any Help
Please.....Bob

 

[Guest]

Hi Bob

You open frmMainMenu
Then go to CreateHoldingInvoices
Then select from a list box (1stModify) to go to back to frmMainMenu

I am lost with this - how do you open the Invoice (is Invoicea a form or a
report)

 

[Guest]

Hi Bob,

It sounds to me like you need to issue a requery command for the affected
control, but it's not clear to me what the name or type of control this
is...possibly a listbox?

Try: Me.NameOfControl.Requery
if the control is on the same form (ie. the reference to Me)

or possibly: [Forms]![frmMainMenu]![NameOfControl].Requery
if frmMainMenu is open, and you want to do this in the click event of your
button that you use to return to this form.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________