Autofill

[Frank]

All

Newish to Access 2000.

I want to create a form with 3 fields:
Bird Species
Scientific Name
Species ID number

Each 'Bird Species' has a related 'Scientific Name' and 'Species I
Number'.

I want to enter data into any one of the fields and have the relate
data autofill in the other 2 fields.

If this is too complicated for me to set up then just able to ente
'Bird Species' and have the other 2 autofill would be fine.

Can you help?

Fran

 

[Frank]

All

Just had another thought which may be easier, I don't know?

If I had each field as a combo box, if I scrolled through the 'Bir
Species' combo, to have the other 2 boxes scroll through their relate
data at the same time?

Thanks

Fran

 

[Pat Hartman]

The easiest way is to use what is known as an "autolookup" query. Simply
join the two tables and select the columns you want from each. Then change
the form's recordsource to be the new query. As you type in the Bird
Species, the related values will be pulled automatically from the
BirdSpecies table.

 

[Frank]

Pat

Thanks for your reply.
However I only know the basics of access so bear with me!

I have 3 tables:

Species
ID (Primary Key)
Species

Scientific Name
ID (Primary Key)
Scientific Name

ID Number
ID (Primary Key)
ID Number

What do you mean 'simply join the tables'?

Then, how do I set up an autolookup query and change the forms recor
source.

Sorry, i'm new to this but don't want to let it beat me!!

Regards

Fran