Search results

yes, i noticed the additional quote earlier and corrected it in the first implementation with Goto. The NZ solved my current issue. Thanks Both.

Thanks i've implemented the dcount = 0 code. It works but there is a small issue, if the user doesnt key anything into the field and hits enter, run-time error '3075' will result. It states ...Syntax error (missing operator) in query expression '[Job No]'=' ...

Yes its just for viewing and no edits. Thanks i tried it and its good.

Why is Goto nasty?

Thanks I'll try that out.

How do I set the details portion of the main form to be "no edit" but still have the combo boxes in the header of the main form able to key in data to get the correct record? I'm trying to make the form & subform records just for viewing only but the records are searched by the combo box in...

Actually the the opposite of what you posted is what i actually want. But based on your example i added a goto to jump till the end and it works. Thanks.

Hello, How do I change the textbox background color and font color, when its enabled property is set to 'No'? Its pretty hard to see the values inside the textbox when disabled. :p BP

I've found out why the validation didnt kick in. Its because i have some code in the On_error event of the form. When i removed this code, and a non date entry is keyed in, the standard date field validation kicks in fine. But I've no idea how to modify the code to allow the standard field...

erm... how do i code this for Dlookup, its the primary key in the other table. Does the below look right? dim testing as string testing = DLookup("[Job No]", "[QT Job Record]", "[Job No]" = " & Forms![QT Job Update]![Job No]) THen put an IF statement to test the testing string.... hmmm what...

anyone knows?

This run-time error 3101 is caused by the entry of an ID into a textbox which is not inside the "One" side of the table. As I have form.refresh in the afterupdate event of this textbox, immediately it pops out this error and prompts me to end or debug. How do i make it prompt a msgbox instead...

Thanks. That works great.

Some more info about the table design and textbox control properties in the picture attached.:confused:

Thanks all!

I've not done any formating for the control. when i key something that is not a date entry it just does nothing. the focus is still at the control but nothing happens, it doesnt switch focus to another control and the form does not update. here's the SQL for the form source if this means...

Hello, lets say i have 10 textbox in a data entry form, the user enters data into the 10 textboxes. when the user reaches the last text box, and after entry and hit enter, it automatically goes into next record, how do i prevent the form from going into the next record and stop at the last...

I have a date textbox on a form based on a query, this date is from a table where the field type is defined as date, but when i enter something else other then the date, the system warning to state the entry isnt a valid date doesnt kick in. however if the form is based on table, the warning...

lol, i dun't know how to explain it any clearer. If the form updates it doesnt matter. The entries into the form controls go into Table A which is the source of the form. I'm talking about adding the values of these controls into another table B fields. Lets ignore the above and start afresh...

Right, that was what I was trying to ask. How do I add the fields together... in vba code ? [tblRecord].[A] = [tblUpdate].[A] + [tblRecord].[A] ??? Doesnt seem right though...As they are joined by the Job_No, how do i get the values to be inputted into the right row(job_No) and...