Automatically putting names in a form from another form

  • Thread starter Thread starter Charlene
  • Start date Start date
C

Charlene

I have a form[General Site Information] that has several
subforms. There is certain information that I have been
able to automate into the subforms(i.e. I put this in the
default value in properties =[forms]![General Site
Information]![Center Name]and the center name
automatically shows in the sub form) I have an attendance
record and I want to have all the names of children
automatically put in when I enter the form. I Have tried
entering the same formula as above and I have been getting
a #Name? error. I am not sure what that means. Is it
possible to have multiple names put in at the same time or
will I have to manually put them in. I hope I am making
sense.

Thank You
Charlene
 
It sounds like the default was using a single text box on the subform
and the one causing a problem is multiple items ?
If so, you may need to .Additem to a listbox. Or are you trtying to
get the listbox automatincally created on a sub-form based on the main
form selection criteria. If you only want a simple list of the names
in a text box, you'll have to set up a long string maybe comma
seperated and put it into a large text box but I don't think you mean
this ?
 
Are you trying to put a list in a text box ? If so you will need to
concatenate them maybe comma separated. Or are you trying to add a
list into a list box, if so you need Listbox.Additem for each child
name
OR
Are you trying to get the data from a table based on criteria in the
main form ? If so you need to link the Main and Sub forms together so
that any criteria in the main form can be used in the query of the sub
form.
 
Back
Top