I have a table of people. I view this through a query People Maintain.
I created a simple form People Maintain Subform. In design this works fine in either datasheet view or a form view.
I drop this subform onto another form Maintain People. This now works fine but I can see no way of influencing how the subform is displayed. It appears by default as a datasheet (which is what I originally intended). This it claims is form view. If I try to select datasheet view all I get is a cross in the corner of the screen.
Anyway what I then try to do is, for any given line in the subform, I would like to click something and get a full form view – not all the data fits on one line.
So I create another form People Maintain Detail, based on the same query. This works fine. Now to connect everything.
I go back to Maintain People and go into design view. This shows the subform as it would be in form view. I create an event for double click on surname field . The event is a Macro:OpenForm
Form Name
eople Maintain Detail
I try these options for Where:
[ID]=[Forms]![Maintain people].[ID]
[ID]=[Forms]![People Maintain subform].[ID]
[ID]=[Me].[ID]
In each case I get an Enter Parameter Value dialogue box.
What am I doing wrong? How can I connect the form to display the record I have double-clicked? Or can I somehow get the subform to show in form view?
I created a simple form People Maintain Subform. In design this works fine in either datasheet view or a form view.
I drop this subform onto another form Maintain People. This now works fine but I can see no way of influencing how the subform is displayed. It appears by default as a datasheet (which is what I originally intended). This it claims is form view. If I try to select datasheet view all I get is a cross in the corner of the screen.
Anyway what I then try to do is, for any given line in the subform, I would like to click something and get a full form view – not all the data fits on one line.
So I create another form People Maintain Detail, based on the same query. This works fine. Now to connect everything.
I go back to Maintain People and go into design view. This shows the subform as it would be in form view. I create an event for double click on surname field . The event is a Macro:OpenForm
Form Name
eople Maintain DetailI try these options for Where:
[ID]=[Forms]![Maintain people].[ID]
[ID]=[Forms]![People Maintain subform].[ID]
[ID]=[Me].[ID]
In each case I get an Enter Parameter Value dialogue box.
What am I doing wrong? How can I connect the form to display the record I have double-clicked? Or can I somehow get the subform to show in form view?
