Query fill a box in a form automaticaly

[vbaInet]

I'm confused what your problem is or what you're trying to achieve with the subquery.

Why are you using a subquery? Why are you not joining the two tables via the common field?

 

[Pusher]

I made a new field in IZVESTAJ called ID_UREDJAJA – who I want to be the current device that is on the street. I want to put this information in this table because the device can change so in two dates we can have 2 different devices. I need this for exact statistic by street and by device. Also I have a different approach with my new table that I will have the info with date, street and device that is on it on that date.

 

[Pusher]

Bottom line is I want to put the device (URS-200, KSS-1 ect.) into my table IZVESTAJ , field ID_UREDJAJA, automatically when I enter the location field ID_RASKRSNICE. This information is contained in my linked table RASKRSNICE.[FONT=&quot]Here is my db if you can help i would be grateful. And i don't want to be a linked table, i want to data to be filled.
[/FONT]