Recent content by jdwhytie

can you trap the error with On Error? This way when the error comes in you can check to see if it is the error you want, and if it is then deal with it how you need and return it back to where you want.

Can you put it in your code where you add a new record, that way it will only run when a value is submitted. This way when you put the date in the txt box once, then when you click a button to add the record it changes the default value of the textbox to the date you entered, then, if you...

Is your RowSource correct? Are you sure you have a combo or listbox and not a text box? Have you tried just creating it again? Sorry, I can't figure out how to get what is happening to you to happen to me and am unfamiliar with the problem

I mean did you build the dropdown with the wizard where it steps you through linking a combobox with a table or query.

All you have to do is open your access help file and look for the IIf Function:

Did you build it with the wizard?

Maybe you could do something where after you enter data into the header fields that you want to keep, you click a button that sets the DefaultValue property of the field to whatever you have in it. Then you could have another button that would clear it out.

You seem to be requery the form (which you don't have open) instead of the subform. Try Me!SubForm.requery where SubForm is the name of the subform in your main form -Jake

If they select yes or no in your combo box then why are you looking for the value 1? If Me.Combo2.Value = "yes" Then Me!textbox.Enabled = True Else Me!textbox.Enabled = False End If notice Me.Combo2.Value to get the value of the combobox Hope that helps -Jake

Create a query with your fields for company and product and then whatever other infor you need. In the criteriea for these two fields put in a reference to the field in your form, i.e. Forms!MyForm!ComboBoxName With your form open, running the queary should return your results for that...

Can you reference back to your subform source table and store your values in there with something like: With tbl1 .AddNew !Date = Me!Date !Chemical = Me!Chemical .Update End With Hope that helps -Jake

Set the Record Source of your subform to whatever table or query you are trying to get data from. Then edit your subform so instead of field1 and field2 you have the references to your Record Source field names.

Use SelectObject in your macro

I am able to get the scrollbar to stay showing when I put it in header or footer, but not when I have it on a seperate tab. Does anyone know why this might be happening?

I have a form with tabs. One of those tabs contains a Snapshot Viewer Control. When the form is first opened, the Control is not linked to any source file, i.e. it's blank. I have buttons on other tabs in the form that when pressed, make a snapshot of a report and then place that snapshot in the...