Auto Populate

[mregina]

Hi all,

I tried looking for an answer to this but I haven't found anything yet. I have a form that features a 'Bill To' and 'Ship To' section with 'City, State, Zip etc..' for each one. I'm triyng to create a button that my users can press to automatically copy the data from 'Bill To' into the corresponding fields in 'Ship To' to save time if the data is the same. I tried creating an update query but it seems to confuse the form code and throws errors.

Any help you can give me would be appreciated.

 

[statsman]

Is it possible for you to use a Combo Box. It's easier to autofill fields with one.

 

[CEH]

I use a command button called "same"
After inputing the "JobDescription" if the "CustDescription" is the same the user just clicks "Same"... "cmdSame"

Private Sub cmdSame_Click()

CustDescription = JobDescription
CustAddress = JobAddress
CustCity = JobCity
CustState = JobState
CustZip = JobZip


End Sub

 

[mregina]

thanks!

That worked like a charm...another question:

Can I do the same thing with a sub_form?

I'd like a button that can update date from the parent form to the child form where the joined fields are:

Masterfield = Name
Childfield = BillAddress_Addr1

The two tables being used are:

institution (master)
Invoice (child)

 

[CEH]

With Access and the right code anything is possible Well, almost anything......
But your question leaves me with one...... You have fields on the main form for your billing address and I presume being stored in a table. Why store the same info in another table..???.. (table the subform is on) You do not need to.

PS. I don't think you want Master field "Name" and Child Field "Address"

 

[mregina]

Form

CEH,

Yes, it does seem odd...but I am taking data from Quickbooks and converting it into access, plus the specs needed for my client are very specific..so I need to have those fields update in such a way.

Basically I need to know if an autoupdate button can have criteria limitations, I tried various codes but none seem to work.