access combobox values not showing -

-

i trying create form 3 combo boxes on run report existing data. combo boxes filter down based on data chosen in next level combo box.

however i'm having issues batch number combobox not populating it's list

now vba script:

private sub form_load()     me.cbodate.rowsource = ""     me.cbobatchno.rowsource = "" end sub  private sub cbobottleno_afterupdate()     dim sdatesource string          sdatesource = "select [tblnewcc].[date] [tblnewcc]" & _         " [tblnewcc].[bottleno] = " & me.cbobottleno.value          me.cbodate.rowsource = sdatesource         me.cbodate.requery end sub  private sub cbodate_afterupdate()     dim sbatchsource string          sbatchsource = "select [tblbatchtotals].[batchno] [tblbatchtotals] inner join [tblnewcc] on [tblbatchtotals].[runno]=[tblnewcc].[runno]" & _         " [tblnewcc].[bottleno] = " & me.cbobottleno.value & _         " , [tblnewcc].[date] = " & me.cbodate.value      me.cbobatchno.rowsource = sbatchsource     me.cbobatchno.requery end sub

from can see working alright on vba side can see replacing rowsource of batch number combobox, , in datasheet view giving me results.

enter image description here

however combobox isn't showing in it's list....

enter image description here

unless go in make change , save sql query again.

any clues?

the last part of sbatchsource should " , [tblnewcc].[date] = #" & me.cbodate.value & "#" aside, 'date' terrible name field. reserved word in access , cause problems. here helpful link http://www.fontstuff.com/access/acctut15pfv.htm


Comments

Post a Comment

Popular posts from this blog

dns - How To Use Custom Nameserver On Free Cloudflare? -

-
i have problem. i own small hosting company. trying add cloudflare site free cdn. problem when sign have change nameservers nameservers. have nameserver dns set through godaddy, how add them cloudflare? main site uses company's nameservers whenever add them site goes offline. when go cloudflare's dns records click on dropdown, click ns, , there's 2 boxes 'name' , 'nameserver'. mean input 'ns1' 'name' , 'ns1.domain.com' 'nameserver'? input server's ip addresses? is there way of accomplishing free version of cloudflare? that impossible. option have custom name servers available on business , enterprise. see https://www.cloudflare.com/plans . also, might mistaken. must change name servers in domain register settings, not on cloudflare.
Read more

python - Pygame screen.blit not working -

-
in program creating in python/pygame, screen.blit not working. in other programs have made, screen.blit works. error: traceback (most recent call last): file "c:...\main.py", line 46, in <module> screen.blit(sight.image, sight.rect) attributeerror: 'int' object has no attribute 'blit' the error in question caused screen variable being allocated integer instead of pygame.surface() object.perhaps accidentally rewrote variable somewhere? from can make of doing, seems stating position of blit full rect instead of coordinate. when do: screen.blit(sight.image,sight.rect) what program seeing is: screen.blit(sight.image,(sight.rect.x,sight.rect.y,sight.rect.width,sight.rect.height)) i assuming don't intend this. remember rect object consists of position, width , height. to correct code, put (sight.rect.x,sight.rect.y) location goes instead this: screen.blit(sight.image,(sight.rect.x,sight.rect.y)) the .x , .y corres
Read more

c# - Web API response xml language -

-
i having simple post url clients send post request. http://mydomain.com/requests/request post data: <request> <orderid>1e008921</orderid> <ordername>mc1</ordername> </request> to respond sending them xml <srequest> <requestedby>client 1 </requestedby> <requestname>test name</requestname> <requeststatus>success</requeststatus> <srequest> now client wants above xml in different language (say french ) how handle ? how send response language preference in web api ? specially post scenario ? (append language string ? or best practices ?) i suggest either include in url: http://mydomain.com/fr/requests/request or use http header accept-language . read more in answer to: good way changing language resources dynamically request
Read more