Table Field to Form Field Access 2K

[gdboling]

I am trying to take data from a field in a table and auto insert it into a field on a form. The reason I need it to go to the form is because other data in the form will be different so I need it then to create a new record in the Table when I click to the next record.

[Dana]

Hello,
You can use Me.controlname.value = [your table value]
"Me" is an Access function that associates with the current form.
"controlname" is the name you gave the control (see properties other tab)
"Value" lets Access know what to do
"[your table value]" this is a value [] not needed
Please look into this as I may have left something out.
Good luck,

[gdboling]

What function do I use to make this happen? Do I use the AfterUpdate or what?? Sorry if I sound stupid. I'm new at this. <img src=/S/angel.gif border=0 alt=angel width=15 height=21>

Also, there has to be some sort of check to see what Affiliation is associated with The name. For instance:

If Name = Han Solo then
check Affiliation of that record and insert it into the affiliation on the form.

Does that make sense?

Everything has to be dynamic too, so I don't want to have to create a record that contains every possible name with their affiliation etc, to pull from. I want to pull from the same record I am updating. The code should first check to see if the name exists already and if it does, jump to the autofill procedure that then checks that name's affiliation etc, and puts it in the form to create a new record

[JerryC]

if you are just updating a record why not use a query to fill the form

[gdboling]

Ok, how do I do that? And how do I make the querry run automatically after I fill in the name field?

[JerryC]

set the criteria for the query to the field you first fill in
then in the afterupdate run the query

[gdboling]

A New Example:

In Quicken or MS Money, when you type in the Pay To field, the rest of the fields fill in with the last data you entered for that Payee. that is similar to what I want to do, I just don't want every field to fill in like that. Only fields that remain the same for that Name field.

Make more sense?

[JerryC]

write a query with the fields you need for your form set the criteria of the field you will be typing in to the control of the form
then in the after update of that control run the query

[Brian Swann]

Are we addressing the same problem in this thread that we are addressing the Star Wars analogy thread ? I really think you need to look at table relationships. When quickbooks fills in fields on a form, it isn't creating a record/field, it's using table relationships and yes indeed an underlying query containing the related tables will give you access to these fields in a form or report.