Creating an autofill Form

[Jwnagz94]

Hello people of the interwebs.

I am trying to create a form with a database in Access. The objective of the form is to autopopulate the other Fields after inputting a singular field. I am a novice at Access so any help would be awesome. Thank you!

 

[Micron]

Info is a bit sketchy.

The objective of the form is to autopopulate the other Fields

I presume you mean form controls, not table fields.
create a query that provides the results
create a main form (for any controls that will provide the inputs) and a subform to hold the data; put a subform control on the main to hold the subform
edit the query criteria, using the main controls as reference (e.g. Forms!myForm.txtMyValue)
after the input(s) either click a main form button (easiest if there is more than one input) or use the control AfterUpdate event to requery the subform and load the controls
The syntax to requery a subform
Forms("frmMyFormName").Controls("SubformControlName").Form.Requery NOTE: SubformControlName is the name of the subform control and not the subform

 

[Jwnagz94]

I am a little lost by your instructions. Can you clarify please

 

[Jwnagz94]

Form that Autoinputs

I am currently working on a database in access. I need to create a form that does the following. I need to be able to input 1 field in the form and have that autofill the rest of the forms.

For example: Inputting the client name then receiving the address, email, phone number and have that apply to all the fields.

Thank you!

 

[alansidman]

Re: Form that Autoinputs

Look at this link

Autofill

 

[Micron]

Well, the info is still lacking and presumptions not addressed. Even if I knew what it was you were trying to build (e.g. single form, form/subform, continuous form, datasheet) and what you wanted it to do, it's a lot of work to elaborate when this has been covered countless times elsewhere. I think the purpose of this forum is to help you with an issue where you're stuck rather than be a tutorial for how to build. Here's one of those many sources. If it doesn't cover what you want, try a web search.
Creating Microsoft Access Forms

 

[Joe4]

I have merged your two threads together.

Please do not post the same question multiple times. All clarifications, directly-related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).