How to create an auto-populate blank txt field from a calendar on a form?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
I have two tables:
tblMailing has the customer information with a unique id field "FI_Code". This database is imported monthly.
tblSurvey has about 25 survey fields that will link to the tblMailing database by an "FI_Code".
I need to create a form where the user types in the "FI_Code" and it will auto populate some fields from the "tblMailing" table, and also show the BLANK survey fields from "tblSurvey"
Need to be able to fill out the survey based on the "FI_Code" and have it saved back to "tblSurvey"
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.
1. ActiveX Calendar. Calendar Form opens when you click in control on another form. Need date selected on calendar form to populate [CourseDate] field in other form - doesn't work anymore.
2. List Box - this is more complicated.I need one field to populate based on another - used to work, but now it doesn't.
3. SQL - Using a QBF search. Set up search using SQL statements found on another forum/help site, all but two work like they should.
I have a MAJOR presentation tomorrow so I need serious help. I can send the db to anyone who thinks they can help me.
The customer details are stored on a table and I'm using access 2007. It'sbeen a while since I'
I tried having a column in the query that the form is based on to have a default value of date field + 90 but it doesn't work
This would be similar to how Office or Word does an auto type based upon the initial letters typed.
I've searched the forums and found a number of inquiries regarding auto population, but they're usually tied to another field or table, not the same field in the same database
In order to make it easier for them I would like to automate the process. On the form I have an unbound text box that pulls in the computer name automatically using =GetMachineName(). The computer name is also part of a separate table that includes there name and ID.
I want the form to auto populate the Name and ID field when they open it based on this unbound field called "compname"
This may be simple but I am drawing a blank