djenkins1973
New member
- Local time
- Today, 03:39
- Joined
- Dec 3, 2019
- Messages
- 6
Hi
I'm baffled!
I'm putting together a very simple (initially 1 table, 3 forms, 3 queries, 1 report) database and I'm struggling with something.
I've got all my functionality pretty much as I want it but I'm now trying to create a switchboard.
My main form is a search form that has a subform with data from a query. I have 2 unbound text boxes on the form which have code- Forms(“frmName”).Controls(“frmNameSub“).Form.Requery - in the afterupdate event to requery the subform.
If I open the form from the navigation pane it works but if I open it from a command button I get runtime-error 438 every time I enter text in either text box
If I debug when I get the error I can see "frmName"=empty if I hover over it.
any help greatly appreciated
I'm baffled!
I'm putting together a very simple (initially 1 table, 3 forms, 3 queries, 1 report) database and I'm struggling with something.
I've got all my functionality pretty much as I want it but I'm now trying to create a switchboard.
My main form is a search form that has a subform with data from a query. I have 2 unbound text boxes on the form which have code- Forms(“frmName”).Controls(“frmNameSub“).Form.Requery - in the afterupdate event to requery the subform.
If I open the form from the navigation pane it works but if I open it from a command button I get runtime-error 438 every time I enter text in either text box
If I debug when I get the error I can see "frmName"=empty if I hover over it.
any help greatly appreciated
Last edited: