Subform Datasheet view to Form View

[AmyLynnHill]

Greetings,
I've been messing around with this for a few weeks and need some help.
I have a listbox and on the dblclick event it opens another form and displays a form(participant) that has three subforms. One displays information in a datasheet view (RequestSubform), another displays the participant information in form view(participant) and another displays in form view the request(frmWithReq). I apologize for the inconsistencies of naming. I have attached a copy.
Here's the problem. I want the information to display in form view from the datasheet view, i tried to write some code on the OnCurrent event however, I'm just not getting the syntax correct or something.
If there is anyone that can take a look it would be greatly appeciated!

 

[boblarson]

While looking at your database and reading your description, I'm confused. You don't want the first part to be in datasheet view? Do you want it in continuous view or single view. If not in datasheet view, why not change the default view for the subform while in design view?

 

[AmyLynnHill]

Sorry, I didnt explain very well.

The main form in Participant
Subform1 ParticipantRequest - datasheetview attached to a qry
Subform2 frmWithRequest - formview attached to a table

I want the datasheet view to display the record in the form view

its linked by a ReqID to the subform1.
Each time a record is selected in the datasheet view(subform1) i want it to display in the form view (subform2).

I tried writing Forms!frmWithRequest.requery on the "OnCurrent" event of Subform1, the datasheet view form.
or am i approaching it incorrectly?

 

[boblarson]

I guess I'm not understanding why you don't just change it manually. Is this same form being opened by another process and needs to be viewed with the one form in datasheet view for that process?

 

[AmyLynnHill]

Bob,
I'm not sure what you mean by manually?
The purpose is to display records in datasheet view with a "Few" fields to let the user make decisions. Then if the user wants to see more of the information, they can click on the record and "all" of the fields display in a formview below, one record only.

 

[boblarson]

Okay, that explains it. You really should do this with a separate form. You can double-click on the datasheet and popup a single form to do the edits in.

 

[boblarson]

And the reason I said that is that you are going to find this to be near impossible to do as you envisioned. I believe the change in view has to occur either as the form opens or in design view. You can't just do it while looking at it. Also, you would have issues with showing and hiding controls.

 

[AmyLynnHill]

Thank you for your expertise! greatly appeciated!