Subform Won't Show Data

[Rick]

I'll try and make this short. I am creating a relational database in Access
2007 for a help desk. I'm trying to track the computers that are dropped off
for repairs so I know what's in the shop at any given time.

tables
Customer - primary key CustomerID - AutoNumber - long integer
NewComputer - secondary key CustomerID - Number, long integer

Primary form is Customer with a drop box allowing the customer to
autopopulate the customer fields with his/her data (added from an add form).
Submform is NewComputer with the relationaship being one (customer) to many
(Computer(s))

I want the customer to come in, select his/her name from the drop box, and
then create a new record in the computer submform. The subform was added to
the main form using the form Subform wizard control so the database creates
the link for me. I also have the relationship setup in Relationships and the
link worked and it shows a one-to-many relationship.

Problem: When I select a user from the drop box, the subform goes blank.
Its still there but the data, fields, controls all disapear as if the form is
no longer there.

Thanks for your help!

 

[John W. Vinson]

I'll try and make this short. I am creating a relational database in Access
2007 for a help desk. I'm trying to track the computers that are dropped off
for repairs so I know what's in the shop at any given time.

tables
Customer - primary key CustomerID - AutoNumber - long integer
NewComputer - secondary key CustomerID - Number, long integer

Primary form is Customer with a drop box allowing the customer to
autopopulate the customer fields with his/her data (added from an add form).
Submform is NewComputer with the relationaship being one (customer) to many
(Computer(s))

I want the customer to come in, select his/her name from the drop box, and
then create a new record in the computer submform. The subform was added to
the main form using the form Subform wizard control so the database creates
the link for me. I also have the relationship setup in Relationships and the
link worked and it shows a one-to-many relationship.

Problem: When I select a user from the drop box, the subform goes blank.
Its still there but the data, fields, controls all disapear as if the form is
no longer there.

Thanks for your help!

What's the "autopopulate" here? It sounds like you're creating a new Customer
record each time; instead, you need to have a combo box which *navigates* to
the existing customer record. The Combo Box Wizard will set that up for you.