subform not autopopulating

[slimjen]

All,


using access 2003; i have a subform that I want to autopopulate based combo box select id. ex. main form has invoice# and other data entry fields. I move to subform; select invoice # from combobox from previous records and I want multiple fields based on that record to autopopulate. i know how to make a field autopoplate on the main form but how do I do the same when I move to the subform. FYI. The subform is linked ( parent child) by the invoice number in the tables. Did I set up the subform wrong
help please
Thanks

[RuralGuy]

What is the RecordSource of the SubForm? Do you have the InvoiceNumber as the LinkChild/MasterFields properties?

[slimjen]

yes. I am having trouble turning the invoicenumber on the master to a combo box so that users can choose the invoice number they want. am i on the correct track?

[RuralGuy]

It is better if the "Lookup ComboBox" is not bound and you display the InvoiceNumber in another control.

[slimjen]

ok let me try. when it ask me what i want to see on the form; don't select invoice? instead make it an unbound combo box? thanks

[RuralGuy]

Just add another ComboBox with the wizard and select Option #3.

[slimjen]

option 3? When i go through the wizard there is no option 3. it ask do i want to choose list from table or query or do i want to input. i want to use table.

[RuralGuy]

It sounds like your MainForm does not have a RecordSource. Why not?

[slimjen]

but it does. the form is based on the table used for invoice dataentry. I probably need to begin again. My tables show a one to many relationship. two tables: one invoice and the other tracking info that can belong to an invoice. i have the form for the users to input invoice information. I created a tab control so they can switch from one form to another. i am trying to create a subform for the tracking info so users can enter data based on the cooresponding info from the invoice form. this is where I am having difficulty.

[RuralGuy]

Hmm...maybe some pictures or posting a sample of the db would help. Wherever you tried to add the cbo does not have a RecordSource or you would have gotten an Option #3.

[slimjen]

ok. see attached. also i can't seem to get the subform to view like i set it up in design view. when i view it in form view it comes out datasheet view. thanks

[RuralGuy]

Are we talking about the frm_SMALLPACKAGEINPUTFORM form?

[slimjen]

yes. i know i made copies but i was trying not to mess up what i had. thanks

[RuralGuy]

When you switch the RecordSource of that form to a valid table then the cbo wizard shows Option#3. The ControlSource of the InvoiceNumber control is not valid either.

[slimjen]

can you show me what I am doing wrong please. i can't get a visual. thanks