Very simple one. First create your query in a datasheet form. After that You just create an event procedure on combo category at [after update]. Here chose macro and in macro select open form. But form mode should b hidden means no need to open but just for only action. Save that macro and try...
When you creat a field combo box it ask from where you need select the records here you select your record.
After that on form you need to go that combo proprty and on data options there is rowsurce open that source and select 2 fields but one should be not shown and also filtered by recquied...
You need to go in rowsource in which combo is retrive and then select two fields from table one which is your combo data and second to which you filter tha record. And in critera field put your required criteria
Kindly help me that how i can use vba code that enables me to show pictures from by table to a form?
Now i am coding like
Picture = dlookup from “table login” and further from “IMAGE “ field
Then
Form main ! “Attachment 01” = picture
It show error 438 Any one help pleas
Sent from my...