Hi,

I have a continuous form (bounded to a query that is a result of several queries) and when I click on a control button, I would like to have the value of the EventID field passed to the field (parmEvent) of the unbounded form.

How can I do that ?

Thank you

Chantal

Dim inEventID As Integer
Dim stLinkCriteria As String

inEventID = Me.EventID

stLinkCriteria = "[EventID] = " & inEventID

This assumes that EventID is a number, and that you are passing the number to itself as EventID in the form or report you are opening with this button. Use stLinkCriteria in the WHERE section of the DoCmd.Open... command.


HTH


mmcdonal

Hi,

I did try to use the stLinkCriteria in the "where" section of the docmd.openform... but I get a message because my form is not linked to a query or a table. The "destination" form is some sort of a menu form. I have to select an event in a combobox and click on a control button to print a report, open a form, ...

Now, what I need to do is from a different form, by selecting an event, I want to end up in this "menu" form with the event selected in the combo box.

Let me know if I am not too clear... :)

Chantal

What is the recordsource for the form? Can you be more specific about the controls on the menu form?
Why don't you duplicate the controls from the menu form on your first form? What options does the user have on the menu form that you can't provide on the first form?


mmcdonal