access '97

[grad]

right i'm missing something really obvious here and it's driving me mad..

simply put, not my problem but along the same lines, if i build a form from scratch in design view how do i input the control source..

if i want to a control to be bound to the field 'user name' in the table 'user details' what's the correct method?

I'm sure i've done this before using the expression builder, using it now i get;

=[user details]![user name]

which isn't right!!?!!?!?!?!?! so what's the correct way?

[fugjostle]

hmmm...whats the error your getting? that looks right... is it printing "#Name" or something similar?

As you know, I've not touched access for a while but this might work:

=[user details.user name]

[fugjostle]

Actually it could be =[user details].[user name]

I think the format of the statement is =[Form]![Table].[Field] if memory serves. "." and "!" have a special meanings the above should work. Sod it... its been 2 long mate and I use to do everything in VBA mate. I'll have to install Access and try it myself

[grad]

I've tried all those and variations of...this is something so simple i'll be in bits when i find out how to do it..

your help's appreciated mate.

[grad]

sorted mate...

i need to be putting [user details].[user name] in the record source for the actual form, not the control source of the control.

new it was something simple