HELP, HELP, HELP........plz: Finding and displaying records

[jomichie]

Plz Help Me

I Have a simple datsbase with 2 tables

tblproducts productID primary key
productname text
unit cost currency

tblorder orderID
productID
productname
unit cost

productID are linked
I'm trying to get a form to show the products as a combo box which is
ok, but the unit price does not update

Simple I know But I'd appreciate your help
thankie much John

[Clint Stowers]

In article <ee********************************@4ax.com>, jomichie
<jm****@bwr.eastlink.ca> writes:

I'm trying to get a form to show the products as a combo box which is
ok, but the unit price does not update

Sounds like a "Me.Refresh" statement might work. Place this in your price
field as an Event (After Update) on your form. This should requery your data
if any changes made to that particular field.

Hope this helps.


"And.... Exactly at which point did you consider this a good idea?"