DataGrid or GridView in Access

P

Participant

Hi,
Is there a way we can represt data as DataGrid or GridView? Moreover, I want
to be able when I select one row to get the value of the ID (the first
column).

Any ideas?
 
A

Albert D. Kallal

Participant said:
Hi,
Is there a way we can represt data as DataGrid or GridView? Moreover, I
want
to be able when I select one row to get the value of the ID (the first
column).

Any ideas?

Take a look at the follwing screen shots for ideas:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

In the above on quite a few of the sample forms, you can see that I placed a
little button called "edit", or a buttion with the glasses icon.

when you click on that button, then you have full access to the record and
you can pop open another detail formed with the following line of code

docmd.Openform "frmCustomers",,,"id = " & me!id

You didn't really give much information as to what you want to do when you
select that one row to get the ID, but the above is the general approch used
in those sample screen shots...

Some people actually don't place a button on the form, but the double click
event on the text box control, and thus double clicking on the text box will
launch the detail form that a lousy to edit the information in a form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top