What exactly does a macro do?

B

BaDonkaDonk

I am not totally sure as to what a macro does, I want to make my database to
set up so I can type in the company name and the address and all of the info
will all come up. I am not sure if a macro does that or how to go about
doing that. I would really appreciate it if somebody could help me out here.
 
A

Arvin Meyer

It is not necessary to use a macro or code to do what you want. A query can
pull up the data you want. There is an example in the Northwind sample
database.

Open the Orders form and begin entering a new record in the "BillTo" combo
box. Watch how the company and then all the associated data comes up. Go
into design view and look at how it was done.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

BaDonkaDonk said:
I am not totally sure as to what a macro does, I want to make my database to
set up so I can type in the company name and the address and all of the info
will all come up. I am not sure if a macro does that or how to go about
doing that. I would really appreciate it if somebody could help me out
Click to expand...
here.
 
6

'69 Camaro

I want to make my database to set up so I can type in the
company name and the address and all of the info will
all come up.
Click to expand...

I'm not sure if you're looking to jump to a record already in the database
or if you want to automatically populate the fields in the form with
appropriate information for each new record. In either case, there are
tutorials available. Tom Wickerath's easy step-by-step tutorial on how to
find a record using a combo box is here:

http://www.Access.QBuilt.com/html/find_a_record.html

And the step-by-step tutorial for using an auto-query to automatically fill
in the fields on the form for new records is here:

http://www.Access.QBuilt.com/html/forms.html#AutoCompleteForm

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
 
Top