View Full Version : working with subform


lamha
06-23-2000, 08:55 AM
I have a combo box on the main form. When I open up, the combo box is blank, but my subform displays the information for the first person on the list of my combo box. How to make all the fields in the subform blank when I first open it.
I also use a calendar control on my main form. What I would like to do is when I click a date on the calendar, the date would be automatically recorded in the Workday field on my subform.
Any help would be appreciated.

Carol
06-23-2000, 08:15 PM
To help with your first question, the subform must contain a link to the main form. Open up your form in design view and check to make sure that the parent and child links have been set.

Good luck

lamha
06-24-2000, 07:33 AM
The forms are linked. When I pull down the combo box and select a person name, the subform changes to the data of that person. The only problem is the subform display something when I haven't selected a name in the main form.

Carol
06-24-2000, 11:49 AM
Go into the properties of your subform and change the cycle to Current Record only.
This should help.

lamha
06-26-2000, 04:57 AM
Thanks, Carol. But it didn't work. The cycle property is for pressing the Tab key.

vickiwells
07-26-2000, 11:40 AM
Did you ever get this fixed? Try changing the Data Entry of the form to Yes.