subforms in access
the form wizard makes subforms quite easily when you have a one to many relationship between tables.
But I have a books table, a categories table, and a junction table between them to facilitate a many to many relationship. Can I make a book entry form containing a categories subform which has listbox fields to input many categories for each each book?
I tried clicking form wizzard while a querry returning the joined books and categories fields
but this didn't digve me what I wanted.
How do I do this?
Andy Kohlenberg
Jerusalem, Israel
Peter J. Boettcher posted this at 14:59 — 14th December 2001.
They have: 812 posts
Joined: Feb 2000
I can't really help you with this one, I don't use the forms in Access. Do you have to use the wizard or can you create a form yourself (sort of like advanced mode)?
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.