Search results

Pat, Thank you very much! I knew it could be done just didn't know how to do it. Not sure my knowledge level in Access will make this easy or not...more than likely not. However, I am going to give it a shot today!!! Thanks again!

TO all, thank you very much...I have the error fixed now, but I still have the same issue, the table that the form is inputting data to still shows the ID column even after making sure column width for column 1 is set to 0. Work in progress!!!

Changed the Table name to...YearCorps Changed the Field name to...CorpsYear I have the control source as...YearCorps and I have the "Invalid Control Source" error??? So here is the setup now Control Source...YearCorps Row Source...SELECT YearCorps.CorpsYear FROM YearCorps;

June7, I originally had it set to 1 and had the same issue, so setting it to 2 was a shot in the dark. Once I get this stupid thing to work like I want it to, I will reset it back to 1 and see if it still works. Thanks for the question, I hadn't thought it all the way through at that point...

Colin, THANKS FOR THE ASSIST! I will rename the table and fields to remove the spaces... Afterwards, I can just delete the Row Source code and redo right, or should I delete that combobox and start over after changing the names?

UPDATE: Row Source...SELECT Year_In_Corps.Year FROM Year_In_Corps; Now I am getting this error: Invalid use of '.', '!', or '()'. in query expression 'Year_In_Corps' The only thing I can think of is the title of the table which now reads.."Year_In_Corps"

Colin, I have tried renaming the field and get the "Reserved word caution" I proceeded and then got the Expression Error (). So I added parentheses around the table name that contains the data and has spaces in the name. still the same issue. I know it is small since ID #1 = 1st and so on...

CJ, I have a table with student names on it, this table contains several columns (fields) all with different data. One of the columns contains the class period those students are in. I need to populate a form with all of the names from a specific class period. ID Last First Class 123 Jones...

No I do not...the table is just 2 columns and only 4 records ID column(auto generated) 1 2 3 4 Year in Program 1st 2nd 3rd 4th

Names of students stored in a table that has a specific field common to them such as...1st period

What is the best/easiest way to populate a form with a list of names that all have the same field in their record... I have a combo that reflects a field on a table. I need to populate a form with names based on this combo box selection.

Hello, I have a form that is used to populate JROTC Cadet data. This form uses combo boxes to select a predetermined value. I have 5 different combo boxes and all of them are working fine except for the last one. This combo box allows selection of the number of years a cadet has been in the...