Datasheet Form - Click specific record and open

[mcalpine]

Hi,

I was looking for a little help.

I have created a Datasheet Form which when opens shows lots of records. I was looking to see if there was a way that if i clicked on a specific field name within a record it would open a new form with all the information of that record only.

Any help would be greatly appreciated. Thank you

Kind Regards

M

 

[mcalpine]

Hi,

I have found the code to open up in a form, please see code below.

Docmd.Openform "Form Name"

but when i click on a specific record it opens up the first record and not the record that i clicked on to view.

 

[JHB]

If you base the form data of a query, then you can use a hyperlink.

Add a field to the query, for example:
Edit:"Edit"
Drag the field on to the form as a TextBox
Set the TextBox's Is Hyperlink property to Yes
Add a procedure to the TextBox's OnClick Event, which opens your pop-up form.

Then it looks like the attached picture.

 

[mcalpine]

Hi,

Not sure how to carry this task out......sorry for being stupid...

 

[peterjb44]

this may help

http://www.youtube.com/watch?v=A5iXuDq741s

peter

 

[mcalpine]

Perfect. thank you very much for your help......

You are a star.....