subform/unique records

  • Thread starter Thread starter TRM
  • Start date Start date
T

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!
 
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
 
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!
 
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.
 
I hate to bother you with it - but I might if I cannot
figure it out soon, if you really don't mind. Thanks!
 
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.
 
Back
Top