So, I'm fairly new to Access so there's still a lot of things I am trying to figure out. Hence, I may make some mistakes in explaining my situation so feel free to correct me.
I created a form that is user friendly name "HOME". In that form, I added navigation controls which include a form in each button (i am assuming these are subforms). These subforms are identical to the regular forms I built them off of (I first made the forms then embedded them into the "HOME" form as subforms).
One of my subforms is "Model Number Search" where I have the person type in a model number in a text box in the subform then they click a button which runs a macro to open a query in a new tab. The query is a union query that looks up records with with the following line as a criteria:
WHERE ((([Service Call Log].[Model Number #1])=[Forms]![Model Number Search].[Model Number]))
This however only works if the original form "Model Number Search" is open and has the value typed into that text box but I am trying to open it from the "HOME" form that also has the "Model Number Search" as a subform. I tried googling what to do and changed the criteria value "[Forms]![Model Number Search].[Model Number]))" to many different versions but to no avail. I was wondering if anyone has a idea of what I would have to do to get this to work.
Below is a picture of my "HOME" form if that helps.
http://ift.tt/1GkduKq
I created a form that is user friendly name "HOME". In that form, I added navigation controls which include a form in each button (i am assuming these are subforms). These subforms are identical to the regular forms I built them off of (I first made the forms then embedded them into the "HOME" form as subforms).
One of my subforms is "Model Number Search" where I have the person type in a model number in a text box in the subform then they click a button which runs a macro to open a query in a new tab. The query is a union query that looks up records with with the following line as a criteria:
WHERE ((([Service Call Log].[Model Number #1])=[Forms]![Model Number Search].[Model Number]))
This however only works if the original form "Model Number Search" is open and has the value typed into that text box but I am trying to open it from the "HOME" form that also has the "Model Number Search" as a subform. I tried googling what to do and changed the criteria value "[Forms]![Model Number Search].[Model Number]))" to many different versions but to no avail. I was wondering if anyone has a idea of what I would have to do to get this to work.
Below is a picture of my "HOME" form if that helps.
http://ift.tt/1GkduKq
Getting a Value from what I think is a Subform
0 commentaires:
Enregistrer un commentaire