Merge directory path with field value

[Eeeeeemil]

Hello everyone!

I'm new to access and VBA and i'm experimenting a little trying to build a project database for my business, i've managed a lot of things so far but i'm stuck on something really simple...

I have a hyperlink field in my form that is supposed to point to a project folder with a number corresponding to the key of the row, something like:

\\yttecserver2\ProjektDB$\Projektmappar\119

But i cant seem to merge the pathway "\\yttecserver2\ProjektDB$\Projektmappar" with the field for the rowkey [ProjNr] to a path...



What i've tried so far is simply putting "\\yttecserver2\ProjektDB$\Projektmappar"+[ProjNr] In the standard value for the field, but it prompts me with this:
"the field 'ProjNr' in the verification expression or the standard value in the table 'ProjData' are not valid in the database engine"

Any help?

[ranman256]

="\\yttecserver2\ProjektDB$\Projektmappar" & "\" & [ProjNr]

[Eeeeeemil]

Thanks but it didn't help. It's correct that i was missing a \ in my previous comment though.

I tried "\\yttecserver2\ProjektDB$\Projektmappar\"+[ProjNr] and putting it in the settings for the text field itself instead of the table, whenever i create a new row (using the form) it now has the standard value "\\yttecserver2\ProjektDB$\Projektmappar\" allthough it still doesn't link to the folder itself (ProjNr).

I think this might be due to when i press "new" in the form there hasn't yet been a number assigned to the row until i acctually write something in one of the fields of the form. Anyone know a way to get around this? I trid to but in "on click" hoping that when i press the hyperlink field it would update with the right path but i doesn't.

[aytee111]

The event to use is the AfterUpdate event of the ProjNbr control. Create the correct path after an entry has been made in ProjNbr.