Access, 1 - question user how many children they have, 2 -....

  • Thread starter Kostas - Australia
  • Start date
K

Kostas - Australia

After a user is questioned on the number of children they have, I would like
the form to open that many drop down fields, so they can choose the children
from the contacts (already in contacts table)
 
S

Steve Schapel

Kostas,

Well, the basic process you would have to follow here is to run an
Append Query that writes the requisite number of records to the Children
table, and then Requery the subform. And the subform will have its
Allow Additions property set to No, so they don't have access to more
than that number of records. Hope that makes sense.

A complication I can see here is that you might also want to check that
they do actually enter children for the number they say they have. What
do you want to happen if one of the comboboxes is left blank?
 

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

Adding custom menus to existing excel application 0
Daycare Birthday Program? 2
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Option Group data display 10
how to handle children of parents in contacts table 2
Link a text box based on drop down box with four options MS Word 365 0
Group by month 2
Possible? Variable X and Y data sources and Auto Charting 0

Top