Auto-populate and Attachment Problem
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I then realized that with that setting users can enter duplicate data. When I changed Indexed to Yes(No Duplicates) I lost the auto populate function.
I would like to have the best of both worlds. I need the field to stay Unique as well as populate those 3 fields.
I have an employee table that shows employees and some basic information about each of them. This table has an employee ID field that is not an autonumber but it is unique to each employee (10004928).
I have other tables that also use that same field and I want the first and last names to auto populate based on the main employee table. These other tables are tracking OT and Vacation time used.
How do I make the later tables auto populate the name fields when you key the employee ID?
I want to have a field (field 3) auto-populate based on what is entered into two other fields (field 1 & field 2).
Field 1 is a date field (when a presentation is due). Field 2 is a yes/no checkbox (if checked, it means no presentation is necessary). Field 3 would be a calculated text field (?) because text cannot be entered into Field 1.
If field 1 is null and field 2 is checked, then I want "NA" to auto populate into field 3. However, if field 1 is null and field 2 is not checked, I want "TBD" to auto populate into field 3. If field 1 is not null, then I want field 3 to be null
my problem is how can I automatically populate the
data into the combo txtbox2 after I updated or input the data
in combo txtbox1.
wish I could have the answer soon. this will help me more in my project.
There are three tabs on the form, each is populated by the user with data for the record, and each of these tabs is putting data into a specific table (one for each tab). Not sure if it is relevant but the value going into the fields inquestion are the primary key fields for two of the three tables.
When one of these fields is populated on the form, the other two automatically populate with this value.
However, this is the only way they can be populated, the number has to go into the textbox for field 3, and field 1 and 2 populates. I can't enter into field 1 or2.
This is how we would like it to work, but I want to populate one of the other fields first (field 1), and the remaining two auto populate.
The problem is, no one here as an access expert and no one nor I can understand how these fields are linked? Everyone is scratching their heads at it.