Form and subform

[Guest]

Could you build a form and subform from the same table

 

[Allen Browne]

Not a good idea, Lee. You will cause yourself more problems than you will
solve, including concurrency issues, and possibly even messing up the Seed
of the AutoNumber field.

If you wanted the subform so you could select a record to edit, you could
use a list box instead for the navigation on the unbound main form, and then
put a Form view subform in the subform, naming the list box in the
LinkMasterFields.

 

[John Vinson]

Could you build a form and subform from the same table

Yes.

You're likely to run into trouble editing records, though, since you
can't have two different forms editing the same record at the same
time.

What are you trying to accomplish?

John W. Vinson[MVP]