Auto click on a field

[Sniper-BoOyA-]

Good Morning,

Ive come across an old form i made somewhere last year. And it needed an update.

I added a field to the table which uses a lookup function, and gets one single value from a seperate table.

When i put this field on the form, the value of the field is shown, but the formulas based on that field are not functioning untilll i click on the field in question.

Its like it acts like a dropdownmenu and has a afterupdate event. Is there away to simulate a mouseclick on that field, so that the user doesnt have to click the field for every id (autonumbering)?

I know theres an SetFocus, but that doesnt seem to work.

Cheers!!

 

[CBrighton]

the value of the field is shown, but the formulas based on that field are not functioning untilll i click on the field in question

I'm a bit confused, the value is shown but the formula isn't working? Then how did the value get there?

Or are you saying the value from the previous DLookup is still there but the correct value may have changed so the DLookup needs to fire again?

You could just send the DLookup to the control on the form current event. That way as soon as a user accesses a record it should send the value from the DLookup to that control.

 

[Sniper-BoOyA-]

I'm a bit confused, the value is shown but the formula isn't working? Then how did the value get there?

Or are you saying the value from the previous DLookup is still there but the correct value may have changed so the DLookup needs to fire again?

You could just send the DLookup to the control on the form current event. That way as soon as a user accesses a record it should send the value from the DLookup to that control.

Ya something must have been wrong with the field itself. Because when i removed it from the form and re-added it, it was a dropdownmenu.

Which brings me to the following question,

the form has an field named "id" which is an autonumbering field.

At this point i have a total of 8 id's. (1,2 .. 8). Is it possible to say that if i select the value of the dropdownmenu, the other 7 dropdownmenu's will also get the same value?

 

[CBrighton]

If you mean that when you set it for one record that value is applied to all records then sure.

Easiest way would be to run an update query on the after update event.

 

[Sniper-BoOyA-]

If you mean that when you set it for one record that value is applied to all records then sure.

Easiest way would be to run an update query on the after update event.

Yes it worked ! thanks m8!

 

[boblarson]

Because when i removed it from the form and re-added it, it was a dropdownmenu.

Your statement there makes me believe that you are using lookups directly at table level when you should not be doing that. Read this for why:
http://www.mvps.org/access/lookupfields.htm