newb seeking help with form

[Ryan Case]

I am using Access to store data from a CAD program. We then in turn have
another program pull data from Access to drive computerized saws. In
order to get the data from the CAD program to Access, a report must be
ran within the CAD program. This generates a .rpt comma delim value
file. I have been putting this into excel and then creating a linked
table withing Access out of the excel file.

A simple delete query and then append query does what I need to as far
as removing the data from the "master table" and then replacing it with
updated data after the .rpt file has been re-ran. (See everytime a
change is made in the CAD program)

What I would like to do is this. Creat a form with two combo boxes. The
combo boxes list all of the models that we produce and the four seperate
master tables that we use. The user picks a table from one combo box,
and a model from the other and then hits an execute button. This would
invoke the appropriate delete and append queries for the chosen model in
the chosen table.

I can get the delete and append queries o.k. What I can not sus out is
how to put the combo boxes on a form that control a which event
procedure to run.

Any thoughts or help here will gain the helper many many internet karma
points. Even if your advice is that there is a better way of doing this.

TIA,

Ryan

[Trevor Best]

Ryan Case wrote:

I am using Access to store data from a CAD program. We then in turn have
another program pull data from Access to drive computerized saws. In
order to get the data from the CAD program to Access, a report must be
ran within the CAD program. This generates a .rpt comma delim value
file. I have been putting this into excel and then creating a linked
table withing Access out of the excel file.
CSV from CAD? Pah! What's wrong with good ol' Isogen format? <g>
I can get the delete and append queries o.k. What I can not sus out is
how to put the combo boxes on a form that control a which event
procedure to run.

A simple case statement would do, e.g.

select case MyComboBox.Value
case "This"
RunThis
case "That"
Runthat
case else
DoSomethingElse
end select

--
[OO=00=OO]