Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using a form dialogue to capture Input Parameters for another form 1

Status
Not open for further replies.
Mar 16, 2006
2
GB
On an Access Project ADP file - I have been able to use a form dialogue with combos to "Set value" of parameters on a Report "Open". However, when I try to use identical method (identical underlying function)for opening a Form the input parameters are requested first and then the form is opened rather than looking for the dialogue form to set these values (as with report method).
The input parameter looks like this:
@EnterCostCentre=[Forms]![FL_CostCentreRequirementNameDialog].CostCentreLookup,@EnterRequirementID=[Forms]![FL_CostCentreRequirementNameDialog].RequirementNameLookup
 
try just putting the parameters in the properties of the form (the input parameters option.) instead of in the VBA.

 
Thanks, but I was using the input parameters option within properties. However, I have since found a better method than using a dialogue form to access a form and that is to include the combo lookups within the header of the form and run a Refresh form macro on After Update event. Works well.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top