Opening specific form fecord from datasheet hyperlink

[pavle989]

Hi,

I am trying to build a very simple database, but I am stuck at this seemingly simple thing. There is FIRME_DS datasheet, and I made the first row hyperlink.
On click event, I made the open form event to open editing form to corresponding data. But, when I click on hyperlink it opens "Enter parameter value" dialog. Anyway, when I manually enter the name of the record i want to open, it works.

I would appreciate any help. Thank You

 

[pbaldy]

Your field is text, so needs delimiters. Try a where condition of:

="[NAZIV FIRME]='" & [NAZIV FIRME] & "'"

 

[pavle989]

Ok, that was It.
Thank You so much, it really was really annoying

 

[pbaldy]

No problem, and welcome to the site by the way. This is VBA syntax, but I think similar rules apply to macros:

http://www.baldyweb.com/wherecondition.htm

 

[moke123]

bear in mind that using a text primary key with single quote delimiters will still fail if the field contains an apostrophe such as Sunny's or D'Angelo.

 

[pbaldy]

True. I'll go a step further and say you shouldn't use the text field as a key anyway. Sooner or later you'll have 2 with the same name. I'd use an autonumber field as the key field, or at least a numeric field.