Search results for query: *

I have form A which has field "FID". I want set the value FID=Me.OpenArgs when something changes in my form I tried setting the value in form close but it didn't work. Where should I place my code? None of the field is mandatory except primary key which is automatically generated. I have...

I have a report which has line after every control. After first page I get just one line in second page. How to avoid this? I decreased line width but the problem still exists. I'm not able to decrease the size of the report in design mode. I'm also getting blank page. How to slove this? thanks

I'm using OpenForms function to open form B with specific record from form A. If the record is present in Form B then it should show the record and allow user to update else if not present then user should be allowed to enter new record in Form B Function OpenForms(strFormName As...

I would like to prevent the user from entering new records I used With frm .AllowAdditions = false .AllowDeletions = True .AllowEdits = True End With User should be able to update and edit. If the form has no records then form will be blank. Form doesn't even show the controls. How to...

How to set the record source for a form where form name varies depending on where it is called? My form name is stored in stFormName I have to set this property in different form. I tried following but doesn't work Forms(stFormName).RecordSource = mstrSQL Forms!stFormName.RecordSource = mstrSQL...