vba - Requery combo boxes in Access 2013 -

-

i've created 2 dependent combo boxes in form. if choose category in first box, filter list of products available in second. i've saved category-product selections table called test, categories 1 row each.

what i'd display product in product combo box if select category in test. example, if select category=condiments , product=ketchup in form, it's added test. then, next time select category=condiments in form, products combo box (the box type, not dropdown) show ketchup. seems work if have 1 row in test. if add more rows, productcombobox not change.

here's how form constructed.

in rowsource categorycombobox, select everything

select * categorytable

in rowsource productcombobox, filter products based on category selected

select * producttable producttable.categoryid=[forms]![formtest]![category]

the form source products left joined category on categoryid.

in on change event categorycombobox , on current event form, requery productcombobox

productcombobox.requery

however, using productcombobox.requery requeries options available in dropdown. doesn't change current combo box value after selecting category before selecting product. how requery data table linked controlsource? there better vba function requery, or need use sql in macro?

in onchange event of first combobox, following:

 private sub category_change()       dim myid long       me.productcombobox.requery       if not isnull(dlookup("productid", "tbltest", "categoryid = " & me.category))            me.productcombobox = dlookup("productid", "tbltest", "categoryid = " & me.category)       end if  end sub

then update test table, in event want update "default" option, put:

 currentdb.execute "update tbltest set productid = " & me.productcombobox & " categoryid = " & me.category

this assumes "tbltest" has record each category. if not, can generate checks , insert category table.


Comments

Post a Comment

Popular posts from this blog

ios - Memory not freeing up after popping viewcontroller using ARC -

-
hi project arc based, using uinavigationcontroller make transition between viewcontroller. using profiler analyse happening behind scene memory. noticed when push viewcontroller allocate memory components , when pop not freeing allocated memory. since using arc unable implement dealloc or release component. have analysed in detail , there no memory leak in project. i not using strong property push viewcontroller. here how pushing viewcontroller. viewcontroller *obj = [[viewcontroller alloc] init]; [self.navigationcontroller pushviewcontroller:obj animated:no]; any clue whats going on? should free memory have consumed. please advise your description indicates have retain cycle, leads objects not being deallocated. typical source of retain cycles properties assigned loading nib files (usually declared iboutlet ). two strategies break them , release objects: declare property weak : @property (nonatomic, weak) iboutlet uilabel *statuslabel; set property nil in...
Read more

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more