Search results

Rich, Sorry I am not understanding what you are saying.

Yes, in the same table.

Have a huge Order once a month for a buisness and has to fax the order to them. How could I do this where I could type in the product number and the description would come up automatic?

FOR ARNAUZ Am interested in your code for this. Thanks danaleblanc@yahoo.com

Have a checkbox called RUSHORDER Have a text box called UNITPRICE (formated in currency) Need a code that will increase the value in UNITPRICE by 30% if RUSHORDER is selected. Any help is appreciated.

This code did not work. Do you have another method?

Have a check box called 'rush orders' Have a currency field called 'unit price' Want value in unit price to increase 30% if check box is selected. Any help is grateful.

Maybe I am understanding this wrong, but I do not use a query. It is a subform. In the subform I have these fields Student ID Date of test Name of test Grade Overall Avg Subform has 5 records everytime. The 'name of test' field is a different name each time, but the same for each subform. I am...

Would I be able to get a subform to list 5 records automatically if a field has 5 different values in them? It is a repeat entry, that I am trying to avoid. Thank you

I figure that was the only way. I wish I saw the database before company started inputing data in it. Anyway, thanks for all your help.

Your right, it can be done if we redesigned it. My question is is there a way I could do it without building another database. How do I send this database to you?

Thanks for your reply. Have a table with fields for a company and the chemicals it uses. The form allows user to input a company and the chemical it uses. The problem is if the company uses 20 different chemicals, the user has to input the company (same) information 20 times. Would it help if I...

On a form that has all ready been design, user needs form to be able to only have to input company name once and be able to input many chemicals. Can this be done without having to build a new database?

Thank you for your reply. The reason I want the subform to list 5 records automatically is I want a field to list 5 different values in them.

After a subform is created, would I be able to have a field list five different records automaticly?

It worked - thank you

I did just like you said and it still don't work. I wrote over the word [Event Procedure] I am sorry, I hope I am not testing your patience.

It does not work. Here is the code I typed PO Number.setfocus in the On Click event

I want clicker to appear in anther field after I click 'Add new record'

Thanks for message. When I enter this code, I get an error message saying Chemicals can't find a macro 'FacilityName' and won't view form - What am I doing wrong?