How to Create Automatization with Macros?

[Guest]

Hi, I am trying to figure out how to create a table with all the data on the
"form" with a bunch of combo boxes, in the series of "records." Is there one
way that I can just select some of the other data on a particular data on the
combo box and have the data of the other fields changed to the state as they
should be, without me having to click on arrows to look at other records?

I am desperate. I cannot find this function explained in the assistance
tutorials on your website.

 

[John Vinson]

Hi, I am trying to figure out how to create a table with all the data on the
"form" with a bunch of combo boxes, in the series of "records." Is there one
way that I can just select some of the other data on a particular data on the
combo box and have the data of the other fields changed to the state as they
should be, without me having to click on arrows to look at other records?

I am desperate. I cannot find this function explained in the assistance
tutorials on your website.

Well... it's not OUR website. We are not Microsoft, and we don't work
for Microsoft. We're all independent volunteers here.

I have NO trace of a notion what you mean. What "particular data"?
What is the state that "they should be"? You're speaking in
generalities, assuming a knowledge of your requirements which we lack.

You should start with properly normalized tables, where each Table
represents a class of Entities (people, things or events of importance
to your application). A Form is just a tool, a window onto the data in
the table; you can use combo boxes, checkboxes, textboxes and other
controls as appropriate to display and edit the data in the table. So
you don't "create a table with all the data on a form" - you create a
Table; then you create a Form bound to that table, with controls on
the form bound to the fields in the table. Macros are almost certainly
NOT going to be involved, though VBA code (stored in Modules) might.

If you could describe the nature of the data that you wish to manage,
we should be able to help.

John W. Vinson[MVP]