Subform showing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form with subform which are linked by "SBID". The record
source for the form is "qryMainNewDataSBID" and the subform are
"qryStageError" and.
When I open the main form, it opens with all the fields empty, ready for
data. The subform opens with the previous data still in the fields and I'm
not allowed to change it. the default
Can someone please help me wiht my problem. Much thanks in advance.
 
Greg,
You need to enter the Master Child properties for the subform to link the two
forms.
See signature for more help.
Bob said:
I have a main form with subform which are linked by "SBID". The record
source for the form is "qryMainNewDataSBID" and the subform are
"qryStageError" and.
When I open the main form, it opens with all the fields empty, ready for
data. The subform opens with the previous data still in the fields and I'm
not allowed to change it. the default
Can someone please help me wiht my problem. Much thanks in advance.
Click to expand...

--
Bob Heifler
My Access Program, Owner
www.myaccessprogram.com
info (At) MyAccessProgram (Dot) com

Message posted via AccessMonster.com
 

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

Unremovable horizontal scroll bar on subform 1
Access Main form/Subform Navigation 0
VBA Syntax for subform record source change 6
First Subform record gets modified when closing form 3
data entry in subform before mainform causes huge hassle, HELP! 2
Set Change Event on Control from Nested Subform 0
Go to a Specific Record on a Subform 3
Set focus in a specific record within a subform 1

Back
Top