Recordsetclone or bookmark help....

[docmeizie]

What I have is a form that opens another form. The form that is opened I need that form to display the information of the owner of the slip I just clicked to open the form. The problem I am having is I have to do a bookmark or recordsetclone on two comboboxes instead of one. One combobox name is [Slip Location] and the other is [Slip Number]. I know it would be way easier for me to use the customer name as the clone/bookmark, but, it is an expression of the first and last name and Access will not let me set it to that field name.

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv

 

[cmmrfrds]

If you just need to pass a couple of variables to the Form you are opening, then public variables or OpenArg or Filter should work. Please describe what you need to do.

 

[docmeizie]

I have a form called CustomerInfo that is opened from form SlipAssignments. What I have done is created a crosstab query that shows all the slips in each marina location. Well when CustomerInfo is opened I need it to go to a particular Slip Number and Slip Location. In the form CustomerInfo I have the Slip Number and Slip Location Fields set up as comboboxes so I can change those fields to what is selected on SlipAssignments. What I want it to do is change the record to show the customerinformation via the Slip Number and Slip Location. That is why I have to use recordset clone or boodkmark.

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv