Auto-fill one field from another table
I have two seperate tables (called inventory and job log) and they have a few of the same field items (number, name, style 1, style 2, and area).
I would like the job log table to autofill the name, style 1, style 2, and area when you type in the number when logging a new job (pulling this information from the inventory table). It has to be fairly straight forward but I am having trouble trying to make this happen. Could someone please help, I am sick of flipping between tables to fill in the information
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have a field with records like abc(xxxx) and I want to auto fill another new field only with xxx
and if the STUDY ID is new and not in the table, then the users simply fill in all the fields/complete the form and save?
And I would also like a message box to show when I am typing the STUDY ID that would say something like: this person is on the system already. Click YES for this person and NO to add the user?.
I would like to auto fill in the values for field PartNbr, Machine and Area based on the OrderNbr and Oper the user input. I need help with create reference query auto fill those field in either table or Form.
In the form, there is a field that gets filled in automatically by what is entered into two other fields on that form.
The information that is being automatically generated in that field is not saving to the table.
Field 1: Meeting Type
Field 2: Meeting Year
Field 3: Auto-fill field (starts out blank)
Field 1: I choose "Annual Meeting" for the meeting type (this puts AM into Field 3)
Field 2: I choose "2010" for the meeting year (this adds 10 into Field 3)
Field 3: "AM10" is now what shows in the field
I save the data base. I go look at the table and there is nothing in the Field 3 column, when there should be "AM10."
Any ideas about how to get it to save that info in the table
Field A = aaabbb
Field B = aa-aaa
Field C = aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
When I fill the fields I want them to advance to the next field if they have the maximum characters, 6 char in Field A & 5 Char in Field B. I have been able to auto enter the "-" with no problem in Field B. I only use Field C when I want to make a note. I'm not using a form view. I'm trying to avoid unnecessarily keys to continue.
Field A - 6 char auto advance to Field B
Field B - 5 char auto advance to Field A
Field C - I use mouse to select since it's a rare event.
and so on.
I would like to fill in this field automatically when a new record is selected to avoid typos and duplications
I don't know vba at all, so if it's that, I'm done for. Is there anyway to set a default on the table? For example, one field will always say something like $2.95. So, when I add data into the form, I'd like the field to be pre-filled