subform/unique records

[TRM]

I have a subform set up as a datasheet. Some fields are
set to defaults and are combo boxes. A company has a
contract number - this is the link field. An order for a
product is made under that contract - there may be
several orders but for different products. We have a
record for each product (this is the combobox); somehow I
have changed something which causes all the records to
change if/when the product is changed. Any ideas as to
what this might be? THANKS!

 

[tina]

look at the ControlSource property of the Products combo box. it should show
the name of the Product field in the form's underlying table.

hth

 

[TRM]

Thanks for the response!

Yes, the product combo box has a control source
of "Product No" which is the field where I want the
product stored, within the committed table. But, if on
the subform, I tab through, entering the first record and
then try to move to the next record and enter the next
product information, if I change the product, then the
product from the first record changes. Do I have to do a
save command? I thought Access saved when focus moved to
a new record. Or relationships - could it be related to
that? That's what I'm looking at now. So far, it hasn't
made a difference. Also - we have an "old" db to which I
am making updates. This works in that one so I have
tried copying it directly over. Having not changed
anything - it doesn't work here. Thanks again for any
suggestions!

 

[tina]

hmmm, that sounds very strange. if the combobox is bound to a field in the
underlying table, then the value should be stored there - specific to each
record. and to answer your question - yes, the record is automatically saved
when you exit it, either by going to another record or by closing the form.
i can't think of anything else to suggest that you check. if you can't find
the problem, i'll take a look at it if you want to send me a copy of your
db. if so, do the following *to the copy*:
1. remove proprietary data, and enter a few "dummy" records so i have
something to work with.
2. compact the db and zip to under 1 MB
3. refer to the newsgroups in the email Subject line, and send to me at
ttaccKILLALLSPAMMess1 at yahoo dot com, removing the capital
letters.

 

[TRM]

I hate to bother you with it - but I might if I cannot
figure it out soon, if you really don't mind. Thanks!

 

[tina]

i usually only offer when a) nobody else has offered a solution that works,
and b) it's beyond my ability to explain a solution in print - so it's
understandable, or c) i think i could find/fix the problem if i could review
the whole database.
i never offer unless i mean it, in which case it's not a bother if you
accept the offer.
good luck, and i'll be here if you need me.