Invalid Qualifier

[DrowingInVBA]

My code:

Please Login or Register  to view this content.

The name of the combo boxes and text boxes are changed to the ones written above.
ie. the drugcode combobox is named drugcode

1. Somehow i keep getting an invalid qualifier for DrugCode = CInt(DrugCode.Value) and Price = CDbl(Me.Price.Value).
2. before I added the Me. in front of the LastName.text I kept getting an invalid qualifier error as well. What does the Me. do?

[DrowingInVBA]

Please Login or Register  to view this content.

Now it throws an additional error that the method and data member cannot be found
But the name of the combobox is DrugCode

[Norie]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[DrowingInVBA]

MKDRUGEdit.xlsxWorkbook1.xlsm
This is the after^^

The only thing that changed (when it stopped working) was the addtion of the submit button

[Norie]

The combobox on PurchaseForm is called 'DrugCode2' not 'DrugCode'.

Also, on that form there is a textbox called 'Quantity' but in the code you have 'UnitsTextBox' in the Change event of that textbox, should that actually be 'Quantity'?

Another problem, there is no named range DrugCodeList in either workbook.

All of these things caused errors when I tried to open your forms.

If I change 'DrugCode' to 'DrugCode2', change 'UnitsTextbox' to 'Quantity and change the code to populate the combobox to this,

Please Login or Register  to view this content.

I can open the purchase form.

I've just realised the code you posted for the submit button is for the SalesForm, so I've been looking at the wrong form.:oops:

The only problem I can see with that form is the DrugCodeList named range not existing.

Mind you it's getting late and I've been looking at the wrong form for half an hour.

[JosephP]

don't use variables with the same names as your controls since it confuses the compiler. rename the variables and the invalid qualifier issue should be resolved

[DrowingInVBA]

Hi thanks guys the problem was with my naming of my variables

[Norie]

What about the named range?

[DrowingInVBA]

my variables had the same name as the textboxes or comboboxes.

[Norie]

When I tried to open the userforms the code failed because a named range (DrugCodeList?) wasn't found in the xlsx workbook.

Did you fix that?