Duplicate records in sub form

Keesw

New member
Local time
Yesterday, 21:12
Joined
Apr 4, 2004
Messages
5
I have a form which displays name/address etc for a supplier. On this form I have a subform which shows all the contracts which I may have for a particular supplier. The data on main from is taken from a supplier master table (1 record per supplier). The data on the subform comes from a different table which contains the numbers of all the contracts and the relevant supplier. If I have more than 1 contract with a supplier I will have multiple records in this table for the relevant supplier.
As I move through the records on the main form, the contract details on the sub form also change...all fine up to here.
The problem that I have is that if the main form is showing a supplier without a contract...the subform shows a blank value in the contract text box...which is fine. If the main form shows a supplier WITH a contract, the subform shows a contract number in the contract text box AND an additional blank contract text box.
I just want it to show a blank box (if there is no contract) and the contract number(s) if there is one or more contracts. I want to eliminate the blank box in the case of the latter...how do I do that ??

Thanks in advance....Kees
 
I think the blank you are talking about is the row where you would add a new record. If this form is not used to add new contracts, you can change the form properties so that the AllowAdditions property is No. That will elminate the blank line at the end of the subform records.
 

Users who are viewing this thread

Back
Top Bottom