Recent content by collegeprodigy

That helps, but how would I do that same thing in a subform? Thanks saharlan.

Thanks for your help Pat!!!

I have a form with a list box that has two values. For whichever value is selected, I want a different set of fields to pop up. How do I do that?

How do I make it so that saved data (or a record) on a form can be looked through but can't be altered or deleted, while also making it possible to add a new record (as it usually lets you do)? Also, when you update or add a new record into a form, should the data automatically be saved in the...

I need to make queries for forms where there's many-to-many relationships involved. I know that for a many-to-many relationship I need to make a third table where I link each of the other two tables to it with a one-to-many (where the many side is the third table) relationship. I did exactly...

I have a main form with tabbed subforms on it. There are fields on the main form that should link to the data in each of the tabbed subforms, but it doesn't work. Can someone please tell me how to link the data in these forms?!!

Thanks for the reply Pat. Yes, I've been told that my form is too confusing with all of the relationships in there, but that is actually a requirement of my project. So...do you happen to know exactly how to make a form like mine work? If one of the required fields for my form is in more than...

I have a form that has around 25 fields from 10 different tables. When I try to enter a record, the following message keeps popping up: "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the...

is there an auto date function that will put today's date in a record so that the date will stay permanently? someone told me to use the Date() function, but it doesn't work for what i'm trying to do. for example, let's say I create a record with the auto date (or today's date) 4/18/03. then i...

i have a form that includes 30 fields (from 10 different tables). it doesn't work though. could that be because access can't handle it? is there a limit on how many fields and tables a form can use? does anyone know how to make a form with that many fields, from that many tables work? if so...

it really worked! thankx for your help ShannonMarie! :) R. Hicks, thank you for replying to my problem anyway.

just wondering...does anyone know if there's an auto date function in access?

i created a form using the wizard in ms access. i pulled about 25 fields from 10 tables onto the form. in design view, everything looks just fine, but when i go to form view i can't see any of the fields (labels and textboxes) on the screen. the funny thing is that when i go to the 'filter by...