controlling a access form from excel

Originally Posted by Norie

Does this form run a query/report with the value as a parameter?

If it does why not bypass the form and go straight to the query/report?

the form is used to log data in different stages, if you search for a reference number it is also used to update the existing data which is stored in a back end which is locked for end users. The form has the ability to record or update records if it passes the tests required at different stages.

so the reason is simplicity for the end user to only be using one interface to access all information no matter what stage. (certain parts of the information show depending on the stage the record is at, so all for example, "introduction" status wont show the completed date.


The database dump I have is from a query but some end users do not understand or need to understand how queries work which is why everyone just uses a front end.

u know, all these posh sounding business words "harmonisation, fluidity, elegent solution"...

complicated answer for a simple question i know... XD

Dim accapp As Object
Dim DBApp As Access.Application
 
    Set accapp = CreateObject("Access.Application")
    accapp.Visible = True

ChDir "P:\"
    accapp.OpenCurrentDatabase -dblink-    
Set DBApp = New Access.Application
    
accapp.Forms("Request Form").iCode.Value = 3162

so i have this... but I dont have anyway of running the "Search" button macro.
the button has a macro named "Command10_Click" however i dont know how to run it from excel