Search results

Thank you, this formula is in a control source of a textbox.

I am receiving invalid syntax for my formula. A1, A2, and txtAmount is the name of the text box, and they are general numbers. I need to (A1*A2,"",Round(txtAmount*1200/A1/A2/0,0)) =Nz(Nz([A1,0],0)Nz([A2],0),"",Round(Nz(txtAmount],0)Nz(1200)/Nz([A1,0],0)Nz([A2],0)) Thank you

I am going to search type of sort options

Thank you everyone for your help, and thank you theDBguy

theDBguy, that is correct. The combo box would be just two items base on a value list of a-z or z-a to sort a listbox alphabetically. I am assuming the only way to accomplish this would be with a requery. Is there an example or tutorial out there for this solution?

Try looking up spam musubi, that what is spam.

How do you do this? If I was to help, I would say "click here, and select option a. Type code to make the combo box work." That is helping someone

How is that response a help?

I would like to create a combo box that sorts a-z or z-a? How should I go about this to sort data in a list box?

Cool, thank you...Is there a way to make settings so the other form doesnt need to be opend?

I need help incorporating another textbox thats located in a different form to include in part of the calculation. My formula is written like this, but I understand this causing the problem "[Forms]![001Form]![txtAmount]." I probably didn't right it correctly...

MajP, did you get my reply?

I see now, I think kind of understand you. All of column one txt boxes will be combobox that points to the stored data in a table. Same thing for column 3 and 4 will be combobox with a value, list like what you did for the combo box displaying 1 through 10. The last 8th column will be any number...

MajP, how would I able to change a field to a combobox?

Minty take a look the file majP created faketable_v2.

MajP is helping, and created what I am looking for. Just needs a few minor tweeking.

@MajP, I just need 3 combo boxes. @Minty The purpose I ready explained early it just select items a client order. Then last fields adds up all the quantities.

Thank you so much your help :) 1. Would I be able to change the change 3 of the textbox to a combo box, and display stored data?

Thanks that issue is fixed, now for some even those I haven't selected a row. It is showing the first row everytime I open the form.

I attached an image, I got it working but its doing something funny. It was subform record source not point to the table. If you can take a look at the attached image, that would be awesome.