Passing subform parameters to main form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to key in details of PRs for a particular IO. IO details will be
displayed in a subform and PR details in the main form. IO details is control
by a parameter query. i want to pass the same parameter details into the main
form. For example, when i key in the IO number in the pop up, the parameter
will be automatically updated in the specific field of the PR form unless the
user forgot the number and leaves the pop up blank (null).
 
Little code is needed to update the data. You can use code that saves the field value and saves the field value of the main form to the subform field value. If you want it running real-time then you will need to set the main form to refresh on the change. If the subform closes when you key in a value, you can update the main form then. I cant give you the full code, you have to do some work but i hope that helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing a value from subform or main form to subform query 4
Passing a query parameter using code to feed a subform 4
ApplyFilter gives error only when subform is placed on main form 1
Pop-up form that creates record that links 1:1 to main form 0
filtering main form via selecting record in subform 5
Access Main form/Subform Navigation 0
Pass Subform filter to subform in report 0
How to pass, via VBA, a value like [parameter] of a query? 1

Back
Top