Form Dlookup macro

[lukekelly]

Hi all,



Ive had a search for an hour or so to the solution of my problem, but nada so far so thought id drop a quick post,

Lets say i have one table, ive created a form to display certain records in that table. What i wanted to do is to enable an onclick function onto the record ID so it opens a form of the single record. I thus far have managed to do that by the following:

in 'before update' started macro with the 'Set Value' command with the following:

Item:

[Forms]![Tickets Internal Assigned Table View]![ID]

Expression:

DLookUp("[ID]","[ID] = Forms![Tickets Internal Assigned Single View]![ID]")

then an 'onlick' macro of opening the "single view" form - i have tried changing the form names around etc, because its the same table lookup i just want it to pull the record number up that is click, at the moment it is only selecting the first record.

Does anyone have any suggestions? Thanks in advance

Luke

[ConneXionLost]

Hi Luke,

If this is the only location where you use your "single record" form, and assuming you use a select query for that form, then add:

[Forms]![Tickets Internal Assigned Table View]![ID]

as criteria for the ID field.

If it isn't the only occasion you use the form, you could make a copy of it (and the query) for this purpose.

Cheers,

[lukekelly]

Thanks for your reply ConneXionLost,

I have actually sorted since writing this first post, so ill post what i did

I replaced the Expression

DLookUp("[ID]","[ID] = Forms![Tickets Internal Assigned Single View]![ID]")

with

DLookUp("ID","Tickets Internal Assigned Single View")

And also i never done the query for it -.- hehe yeh i know, but it came to me an hour later, well the query anyway!

just had to link the table to its own id and yes as you correctly said with, just a quick question tho if you could possibly answer this the dlookup code i had in first time around, is there a problem with it? i mean i never tried after seeing as i changed the dlookup first then added the query after. Sorry just trying to get my head round these little problems to better my understanding!

Thanks