carry forward entries?

[rmacleod]

I am a novice at Access but I am learning quickly.
I have a form and I would like the Default value of a control to be the Previous value that was entered.

eg.
I have 2 text boxes A and B

A is to enter customer name. B is to Enter serial#.
I have a bunch of serial numbers I need to enter. I would like to avoid having to enter the Customer each time.

Thx in advance,
Rod.

 

[joeselch]

Sounds like you may have multiple serial numbers per customer?

If so, you should have a table for customers and a separate table for serial numbers -- linked by a one-to-many relationship.

Then, when you create your data entry forms, you'll have a main form based on a query of the customer table and a sub-form based on query of the serial number table.

 

[rmacleod]

that was actually just an example....it is not exactly how my form is.

Is there not a way to make default value = Previous value?

 

[Rich]

Article ID: Q136127

 

[rmacleod]

thanks...that is exactly what I needed.

 

[rmacleod]

Mmmmm...will this work in Access 2k3? I just tried it and it doesnt seem to work. no Errors. just doesnt work.