Search results for query: *

the user selects the year from a dropdown box on the very first form, a few forms back before printing a report or entering the data.

adding a bit more detail: i have 3 tables which are all linked in various ways. two of the table have data in them that are year specific. wheres as the one is just a large repository of contact information. i have setup a fourth table (Working_Year) w/ a single field in it (selected_year) that...

Is there a way to have data stored in a table and reference it in unlinked queries and tables to use for filtration?

I have a table (Working_Year) that is storing a single field which is the year (current_year) that is selected by the user in my initial form when the database is loaded. Am I able to use that data in other forms and reports with out linking the table? I would like to simply display the...

i may have described what i was doing incorrectly. i do have multiple forms. one of them i named main and the others i named subforms. now is there a difference in creating a subform vs. creating multiple forms and just having my main form open them up? will that affect the above instructions...

you literally typed =[Parent].[wrkyear] in then? or does [Parent] reference my module location/name? when u added the code to refresh the subform/form, is that in the Private Sub Form_Current() ?

I'm into one of the subforms that will be using the public variable from the main form and am not having success passing the data from the main form over. on the subform, i created a textbox (txt_currentyear) w/ this in the control source field: =[WrkYear] & " Golf Outing" WrkYear was the...

Ok, got it all up to par. Thank you for all of the help. The only thing I’m having an issue w/ is the filtering. i have several forms that are pop-ups. i would like to have on the main menu form a drop down to select the year they would like to work w/. This would set the filtration for...

i didn't see where i could edit my last post so here's my edited version: this is for a database I'm using for a golf outing. i have a table w/ static information (all participant data), then 2 tables set up w/ data that is specific to the year that are linked to the participants (sponsorships...

this is a database i'm using for a golf outing. i have a table w/ static information (all participant data), then 2 table set up w/ data that is specific to the year that are linked to the users(sponsorships and donations). i need a way to have the sponsorship and donations be year specific...

I am trying to write to different tables depending on a user selected variable (ie: depending on the year selected, the data would goto the correct table). Am I able to setup my fields in my forms to reference a predefined variable, then from there write the data to the correct table? Any...