Search results

You could write an if statement in the on click event of the button to check to see if there is anything in the Last Name text box if not use a message box to say enter a last name. If txtLastName = "" then MsgBox "Endter a last name", vbExclamation Else Insert Code to open other form...

Could try something like this: Iif( IsNull([FeildName]), True, False) True = "$0.00" False = whatever your calculation is

Questions - if I do this in the form OnLoad event will it have an impact if a new record is created using the form by another means? Yes it would affect that. So instead but the code back under the button and try: forms![formName]!field = forms![FormName]!BRD_Description = desc not sure...

Instead of trying to set the values here DoCmd.OpenForm doc, acNormal, , , acFormAdd BRD_Type = "CPR" BRD_Title = title BRD_Description = desc in the OnLoad event of the form copy this BRD_Type.text = "CPR" BRD_Title.value = title BRD_Description.value = desc is BRD_Type always going to be...

Are you trying to do this within a form or within the Query itself? How are you entering the Actual Returned Date in manually or is there some code the does this for you?

Here are some thigns that might help you on your second question. Declare your variables as Public (do this under the Option Compare Database at the top of the page) Public doc as string Public title as string Public desc as string or if you want to use these variables on other forms you can...

A question first: How are you realting the two tables together? What are you trying to do with this query (use it in a form/report)?

In an empty column place the code in the field row. JointName: [ClientFirstName] & " and " & [SpouseFirstName]

If the recordsource of the report is a query then you can do the calcuation within the query. Add this to the query: Deal Total: Iif ( IsNull(storage), fright value, (fright value + storage)) Replace with your field names: storage, fright value

Is strSQL decleared as a public vairable. I have ran into this before and ended up going into Modules and creating a new module called variables and then declearing public variables there. Public strSQL as String then use In the On Format Event in the reort section where the text box is...