Subform Question

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

Guest

Hi,

I have a subform with Link Child and Link Masters fields bound to the main
form. The main form is bound to table Departments, while the subform gets
data from table Employees. There are a few records in the Departments table
and several hundred in the Employees table.

Everything works fine until I get to a blank record using the form
navigation button, then the subform refuses to display the next record from
the Employees table.

If I fill in the main form the subform still displays nothing unless I
navigate to the next blank record and then go backwards and forward again.

Is there a way to force the subform to display it's next record even if the
main form is pointing at a blank record?

-Simon
 
You don't want to add a record in the subform until after a record has been
saved in the main form. I believe there is an option to do this with the
command button wizard/builder.
 
Duane,

The subform data is for display purpose so the user knows how to fill in
other parts of the form. Unless it's data is visible, the user won't know how
to proceed.

-Simon
 
Are you expected to see employees with no department? What data are you
displaying on the subform that the user must see in order to proceed?
Proceed where?
 
Duane,

My apologies to you in that I didn't explain things correctly. Nevertheless
I'm trying a different approach to what I'm trying to achieve. See post
"Always Display Current Record".

-Simon
 
Back
Top