Getting value from table on Text Box Set

[khan33]

Dear,

I have to get a vlue from a table on textbox set focus event.

query is as

Select Price
From Product
where P_Name = p

p is a string containing product name to be queried.

 

[John Big Booty]

You could use the DLookup() function to retrieve and assign the required value.

 

[khan33]

Thanks,

What about values from form to table.

Is this DLookup can be used for insertion operation too.

 

[John Big Booty]

You can use the DLookup() to assign values to a bound control.

However if you are able to do this there is probably really non need to store this in another table, as this would violate the concept of Data Normalisation.