Search results

not a subform, but I want it to fill in the remit to information. how do I do a copy command

The remit to is on a different page in a tabbed form

I have on my customer form; Customer Name Remit To Address Address Address 2 Address 2 City...

You are both right and I appreciate helping me figure this out. The code is assigned at initial company setup when a customer is input into the system. It has been the primary method of looking up a customer, but I can fix that since I am creating a new database, with a properly configured query...

Set up as 1st 4 letters of customer name with I start typing customer name the list only shows customers with those first 4 letters. or goes directly to those 1st 4 letters

I think I understand what you are trying to say, and you are right I do not way you to give me something that you would not use yourself. This customer ID I and using is assigned it never changes, stays with the customer forever, even if he leaves and comes back. I enter this code into many...

It is just that a structured customer code is easier to enter in the heat of battle so to speak than trying to remember random assigned numbers with thousands of customers in the system. Call it personal preference, or what I am use to.

I assume this is done by creating an event from the property sheet on the field, using code builder

Sorry I am a bit of a newbie so I need more information, The rule on the other two characters is the first digit of the second and third name or in the absence of those a random 2 digits, either letters or numbers. this would be composed when you type in a customer name while adding a new...

This would be used in the Form

I have a table that has a field called Customer Code and another field called Customer Name. The way I assign a Customer Code is to use 1st 4 letters of Customer Name + 2 additional characters. an example would be "Jones Manufacturing Inc." would get a Customer Code of "JONEMI" 1st 4...

Well the list box approach is not working, I set the Multi Select to simple, no luck, I just get error "this record is not updatable"

will give it a try thanks

I've done a lot of reading but cannot find the answer. I need to create a combo box where the user can select multiple items. Also, I would like to be able to enter the quantity of each is possible without too much work.

Let me be more specific, I have a table with just the list, then let's say in another table called Customers, I would include a field that has list table and define the field in the Customers table as a Lookup? or Short Text? Or, just use Combobox or listbox in form?

Do I need to create a query to go with that setup

So to be clear, I would design it in the table as a lookup the use it on my form as a combo or listbox?

In addition I have several similar List that I use the same way.