Search results

its a weird one, all the names match, it wouldnt be anything to do with the label would it? I have tried setting both the tick box and its companion label to invisible but still no luck. Also used OnClick rather than AfterUpdate. Do i need to add any code to the tickbox i want to make visible...

When i open the form and click on the tick box it asks me to debug the code, and highlights the code: - chkExistingMaterial.Visible = False

Hello, Tried implementing your code KevinM but keep on getting an error when the Else statement kicks in. Both the Demolition & ExistingMaterial tick boxes are fields in a table. I set the ExistingMaterial to invisible also. Private Sub Demolition_AfterUpdate() If chkDemolition = True Then...

Right i will try that. Yeah basically im designing a system, and one of the tick boxes asks 'are you male' for example If the user ticks the box i want two more tick boxes to appear adjacent to the original one with the options (made up): - 1. are you between 40 - 50yrs, 2. are your eyes...

Hello, When you tick a 'tick box' is it possible that an OnClick function can create other tick boxes with further options. (similar to layers in JSP, JAVASCRIPT code). For example, if i tick box A, can this event trigger a function that displays three other tick boxes B, C, D? A bizzar...

Thanks for both your help guys. Both methods work now! Although im abit of a dumbass not figuring out i could use autonumber as the datatype earlier.

Kevin, Darn thing still isnt incrementing. Its remaining at zero still. Have i put the code in the wrong place? Is the Add Job button the right place to put it? Im sure it is though. Ive tried taking out the Dim JobnoID As Long code, and reverting back to calling the variable by its proper...

Thanks Kevin, do you literally replace the DoCmd with the DoMax function and keep the rest of the code the same?

Hello, I'm having problems trying to increment the JobNo primary key when i want to create a new job. The code in comments is the code im working on. The rest of the code is the procedure that kicks in when the Add Job is clicked from a customer details form (that appears prior to the Job...

Hello guys, I have this problem and im not sure the scale of it. Basically the attachment enclosed shows my Job Details form that follows a customer details from...you get the picture. Now i can create a job in the sub form no problems at all, but when i go out of the form and return later...

Cheers guys, ive implemented the: - DoCmd.RunCommand accmdSaveRecord Ben

Hi Neil, To set the scenario out, ive created a 'customer details form' that links to a 'job details form' When i added a new customer entered the details etc, and went to Add Job the new details were not appearing on the Job Details form. I thought a Save button might be the appropriate...

Hello, Currrently working on a form with numerous fields. My question is how can i create a Save button that saves information entered into the form rather than going to the tool bar and 'Save record'? Ben