Automatically entering values

[spacepro]

I have a order database, and what i am trying to do is that when order are being entered in a form when the product is entered , I want the serial code relating to that product to be automatically on the afterupdate event.
I have the products and the serial nos in one table as a lookup.
at the moment i have created lookup tables with combo boxes where the entries are been made.

I have looked in access help on auto fill, but i don't know how to accomplish this.

Can anyone help??

 

[GeoNelix]

Try to lookup and assign the serial number on the Before Update event?

 

[spacepro]

Sorry if I sound a bit thick, but how do I assign the serial code to the product on the beforeupdate event.

Is their any vb code i can use to carry out this procedure or do i assign it through expression builder??

If so how would I express it??

I have only been using access in depth for a few weeks now.

Much appreciated!

 

[FoFa]

I would create a macro, use SETVALUE and Dlookup to apply the value you want on the form. Then assign the macro to the event you want (before update?). This approach seems to be a little more clear for folks just starting out with Access.

 

[spacepro]

i have just created a macro but when i run it i get a message saying
object doesn't contain automation object.
Am i entering the wrong expressions.
Can you help with setting the item and expression values in the setvalue in a macro.

 

[spacepro]

also how do i apply dlookup on the form?
I am not familar with dlookup.

Thanks