Autofill form

[kruger101]

Hello

I'm new to Access Programming and the whole Visual Basic bit and I have a project I need to finish.

Well I created a Form and what I want to do is this:

If I enter an ID number, I want the Form to populate the rest of the fields automatically (eg. phone number, address etc.).

Can you please give me ideas on how to do this? Thanks a lot.

 

[AliBabba]

Sorry for the bump but I would like this too. I created a form "Update Guest" with some basic guest information. I have a guest ID and would like to only fill that so that the rest of the form will be automatically updated.

Thanks