471,355 Members | 1,587 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,355 software developers and data experts.

How to bind table record to form view?

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

Mar 8 '07 #1
3 10719
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
Mar 8 '07 #2
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

Mar 9 '07 #3
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
Mar 9 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Reidar | last post: by
1 post views Thread by nithnat | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.