Recent content by Robbieb29

Hi all I have my database working correctly. I would like the user after entering all data into the form and viewing the report. Export it to excel and then to delete all data from the form in order to start entering new information. Is this possible to do Cheers rob

Sorry to be a pain, but now the user is enable to alter the combo box. I need the user to be allowed to add to the combobox, as there will be locations that are not on the list.

Thanks for the help, i've cracked it using table query. Thanks Rob

I have looked at both threads, and copied the text into my form, but still the fields are not continuing to display the text. I have attached my Database, please tell me what im doing wrong

Thanks really appreciate it

Here is my Database if it helps

Tried this and it still does not work Private Sub LOCATION_AfterUpdate() Me.LOCATION.DefaultValue = """" & Me.LOCATION & """" End Sub

This is what I entered, but it didn't work Private Sub LOCATION_AfterUpdate() Me.LOCATION.DefaultValue = Me.LOCATION End Sub Any ideas

I put the code in the combobox afterupdate section, but on running form view the field remains blank after entering the first location. I would like the value to remain in the combo box until the user changes the locatio. Thus reducing the amount of data to be entered by the user. Thanks

Unfortunately this doesn't seem to work. Any other ideas

Hi I have a database where the user enters the location from a combo box, but when the user goes to enter the next record the location is blank. How do I get the field to show the previous location until a new one is selected then that becomes the default. Thanks Rob

Thankyou Thats was driving me mad, so many people telling me different things. Thanks Again Rob

Hi I have a field in my Table called EQUIPMENTNO and I would like the user to enter a number in the form field EQUIPMENTNUMBER. After all the associated dater is enter the user presses new record and I would like the Equipment number be incremented by one and displayed in the form so the user...