Dgreenwood
Last Activity: May 5 '14, 03:39 AM
Joined: May 4 '14
Location:
-
I have had a good tinker and the "Sub Total" field in the "Book Purchase" table is causing the problem (which is in the form "book Purchase" but is the source of the data.
It is a calculated field and when I have removed the calculation format the Combo Box for "select" works fine but the subtotal no longer works obviously.
I have had a look on the settings and can't see anything...Leave a comment:
-
Sorry,
Microsoft Access 2010
In my Form "Book Purchase" I have the following fields Autofilling from a comboBox field called "search" that has all the information linked via lookup wizard from the "Books" table.
ISBN Number (PK)
Title (of the Book)
Number in stock
Price
The code used to autofill the fields and is currently working fine is....Last edited by zmbd; May 8 '14, 01:52 PM. Reason: [Rabbit{Please use [code] and [/code] tags when posting code or formatted data.}][z{placed images inline}]Leave a comment:
-
Dgreenwood started a topic auto expand on combo box with autofill VBA format issue stops auto expandingin Accessauto expand on combo box with autofill VBA format issue stops auto expanding
I have created a form that has a combo box and that combo box has VBA code that gets other fields to autofill but the problem is my combo box no longer auto expands as I type in in my case a book title into the combo box. I have narrowed the issue down to the price field it has something to do with the currency format.
If I remove it from the code and the auto expand works again and all field bar price autofill. the number format field...
No activity results to display
Leave a comment: