controlling a access form from excel

Here is what I would like to do...

I have a database dump which has includes a reference number I can use to in a form on the database, when I click a button on the form, it gives me all the information related to the reference number.

I want to be able to click a button on excel which launches Access, input the number into the field in the form and then hit the search button...

Im having problem with inputting the number into the field, here is what I currently have:

Please Login or Register  to view this content.

when I am in access I can just use something like this to show me the value:
me.IDCode.Value

however i cant do that in excel, anyone know the correct syntax?

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

Please Login or Register  to view this content.

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

hmm... yeah i just tried to move some code to a standard module but its not gone to well....

the procedure references a function in the original module and the me. commands no longer work... there must be an easier way, even if it means targetting the button and then hitting enter.