Search results

Yes.. My bad.. I think its working now..

Hi arnelgp, I think i did something wrong, if i select value to the combo, it stores the siteid value to tblbuyer

Thanks arnelgp... Your demo works easier for me to follow..

Yes on opening of the form, it should have no records to display until the user selects which siteid to be loaded/dislay.. So i dont need to change the record source (tblbuyer) of my form?.

I have 4 location on tblProperty.. And i have siteid (fk) on tblbuyer.. My form takes records on tblbuyer, meaning it loads all sites (siteid) on opening of my form.. The user (secretary) wanted to load sites per session (edit/verification).. How should i do that.. Pls i need help..

Hello all, I have a situation that I was asked if possible to load records on form after selection on combobox of site id?.

Hi Pat, My bad, yes i have a control sits on subform's header which sums up a control, then i have a unbound control on mainform to display the value.

Hi Pat, Thank u, Yes my control is unbound and it sits on mainform..

Thanks theDBguy, i just add else visible = true.

Thanks for your tip..

Many thanks sir.. I will apply into my first ever db..

Can you pls show me how you did it..

I know this is a basic thing for expert here, but my knowledge of vba is very limited as of now.. I want to hide my calculated control on main form (based on subform control) if the control is no data, null or 0.. Thinking to put some code on my main form on current/open, but no idea what...

Hi the-doc-man, In summary, you are right, my office is hardly buy me a new ms access..

Hi jdraw, Thank you, will check the link..

Hi Pat, Thank you.. As of now, my install / update is only "copy - paste - replace". Can you please guide me to make the install - update automated.

Thanks..

The frmPrintMgr form is stay open behind the report..

Thanks Gasman..

Hello all, Any suggestion(s) pls, i am stack, pls need help.. i could not filter my query for my report..