Form, subform requery problem

G

Guest

I have a form and a SubForm based on the same table.
the form opens, a combobox is selected and the subform requeries
(afterupdate event) based on this selection with no problem, after the record
is added the subform stops requering unless I go back a record and forward to
refresh, but then the subform has a blank record. Is there a way around this?
 
G

Guest

You have a form AND subform based on the SAME table? Something not quite
right there! Different forms usually have their own table or query source.
 
G

Guest

The TABLE logs Daily excersises, sets, weight/reps, the subform is based on a
query of the last 4 sessions of a particular exersice. The Main form is where
you enter you new workout for that bodypart on that day.
 
G

Guest

Not sure you understand the question?? I already have the afterupdate event
requery, if you want more details I will be glad to provide..
 
G

Guest

You say "after the record is added the subform stops requering unless I go
back a record and forward to refresh, but then the subform has a blank
record."

A record isn't added to a table until you have moved to the next record. The
following may help.

DoCmd.RunCommand acCmdSaveRecord
Me.Refresh

Otherwise I wouldn't know
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update subform with combobox change on main form 1
Set focus in a specific record within a subform 1
Unremovable horizontal scroll bar on subform 1
Requery combo box on a subform 3
REQUERY SUBFORM 4
Set Change Event on Control from Nested Subform 0
First Subform record gets modified when closing form 3
Referencing a subform 4

Top