SubForm Causing Duplicates?

[Adam7]

Hi all,



I have made a small sales database.

Customer information from the customer table is on a main form, and on that is a subform that is from the orders table.

So the idea is that the customer's orders appear on the subform.

My problem is that if I enter more than 1 order in the subform, it makes a new record in the form.

I.e. For the 1st record, if I put 2 orders, there will now be 2 records on the form.

For some reason the record count in the bottom left is counting orders instead of customers, I think?

Hopefully someone can work out what I'm trying to explain

Any help appreciated,

Thanks,

Adam

[pbaldy]

A picture might help, but unless you've hidden them the main form and the subform would both have record counters at the bottom. In the scenario you've described, I would expect the subform's to display 2.

[Adam7]

A picture might help, but unless you've hidden them the main form and the subform would both have record counters at the bottom. In the scenario you've described, I would expect the subform's to display 2.

Ahhh, that may be it. The subform's counter is where I'd expect the main form's counter to be (I think).

It's at work so will have to wait till tomorrow but I seem to remember hiding the main form's counter before I made the subform.

Jeezz, how bloody simple. Thanks Pbaldy, that sounds spot on.

[pbaldy]

No problem, post back if you still have a problem.

[Adam7]

No problem, post back if you still have a problem.

Hi, I have scrapped that and decided to edit a similar form used for something else.

It all works perfectly apart from when I change the name of the field that is the primary key.

e.g. It used to be "customer ID", I change it to just "ID", and then when I try and open the form, I'm asked for a parameter with Customer ID.

I'm not sure where the parameter is coming from, the form/subform are based on tables not queries.

Thanks

[pbaldy]

It could be A textbox bound to that field, or the Order By property, or perhaps the master/child links.