How do I auto populate other fields

[Clay]

I've tried several different ways, but cannot get it to do
what I want.

I have a form with the following fields from the same
table;

License Plate
Section
Division
District

I would like to have the form populate Section, Division,
and District after the License Plate is entered. Thanks
for your help.

Clay

 

[Dennis Schmidt]

Hi Clay,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

Depends on where that information comes from. If it is just the same value
every time, open the form in design view, look at each control's property
and place what you want to see in the Default Value property.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support

 

[Clay]

The value for each field changes as the license plate
changes.