Recent content by xveganx007

Thanks Hoa Le, it worked great, you're a lifesaver. matt stewart

i have to create a form that you can choose an organization from a combo box and then type in a new name that you would like to call the organization and also change all of the organizations with that name in the table. how would i go about doing this? thanks in advance, matt stewart

in my form i am currently trying to make it so when i click my command button to exit, it displays a message box if there is a duplicate in the combined fields AUDIT_NO and INDXITMNO (in the record source table for this form there is an index which duplicate values for these 2 controls are not...

Thanks Pat, that did the trick!

i am trying to get the apgno stored in my variable str1 using the values from the feilds AUDIT_NO & INDXITMNO. but i don't know the syntax for doing this. this is what i have so far: strAudit = [AUDIT_NO] strIndex = [INDXITMNO] str1 = DLookup("[APGNO]", "QASALPRA", "[AUDIT_NO] = " &...

thanks, that did the trick, sometimes i miss the easiest things

in my report i have a field that is a total that i get from a query. how would i force the null values to be displayed as 0?

go to tools, starup and then put the name of your form in the display form window, and that will load up when you open your database

Thanks Nick, it work great

when opening a new form from a command button, how can i link the forms using 2 data fields here is the code i have so far (linking just one of the fields, this was made using the command button wizard, i have little vba knowledge): Private Sub Change_Data_Click() On Error GoTo...