How to bind table record to form view?

[Nicolas Boretos]

Hello,

Beginning access user here.
I am displaying the table and its existing form at the same time.
I would like to double-click on a row in the table and have the form go
to/display the selected record.

tia,
nikos

[Allen Browne]

Tables are just buckets to hold records.
They don't have the power to do what you want.

Yon can synchronize two forms, as described here:
http://support.microsoft.com/kb/210060/en-us

Access 2007 also gives you split forms, where you can see the datasheet (on
the left half or in the top half) and the detailed view at the same time
with just one form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nicolas Boretos" <no************@maich.grwrote in message
news:1173349377.811235@athnrd02...

Hello,

Beginning access user here.
I am displaying the table and its existing form at the same time.
I would like to double-click on a row in the table and have the form go
to/display the selected record.

tia,
nikos

[Nicolas Boretos]

Allen Browne wrote:

>
Tables are just buckets to hold records.
They don't have the power to do what you want.

Yon can synchronize two forms, as described here:
http://support.microsoft.com/kb/210060/en-us

Access 2007 also gives you split forms, where you can see the datasheet
(on the left half or in the top half) and the detailed view at the same
time with just one form.

Thanx,

I realized that and bound a macro to an identical form in datasheet view
that essentially has all my fields.

Im using OpenForm with "people1" the target form and the condition

[ID]=[Forms]![people]![ID]

and "people" is the source form

This is bound to a dblclick event, and works.
Then I thought I would also like to be able to go to the record in the
target form when a user clicks the first, next last control at the
bottom of the source form

so I bound this to the OnCurrent event; works, but now the target form
always appears (maybe someone would not want the target form appearing...)

I dont know the name/event bindings for the record control at the bottom
of a form..

thanx, again

nikos

[Allen Browne]

You will probably need to use code rather than mere macros to achieve this.

To test if the form is loaded (assuming Access 2000) or later, use:
CurrentProject.AllForms("People").IsLoaded
so you can operate conditionally.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nicolas Boretos" <no************@maich.grwrote in message
news:1173428485.362866@athprx03...

Allen Browne wrote:

>>
Tables are just buckets to hold records.
They don't have the power to do what you want.

Yon can synchronize two forms, as described here:
http://support.microsoft.com/kb/210060/en-us

Access 2007 also gives you split forms, where you can see the datasheet
(on the left half or in the top half) and the detailed view at the same
time with just one form.

Thanx,

I realized that and bound a macro to an identical form in datasheet view
that essentially has all my fields.

Im using OpenForm with "people1" the target form and the condition

[ID]=[Forms]![people]![ID]

and "people" is the source form

This is bound to a dblclick event, and works.
Then I thought I would also like to be able to go to the record in the
target form when a user clicks the first, next last control at the bottom
of the source form

so I bound this to the OnCurrent event; works, but now the target form
always appears (maybe someone would not want the target form appearing...)

I dont know the name/event bindings for the record control at the bottom
of a form..

thanx, again

nikos