DLookUp

[ttam73]

Ok, I have a form that displays individual information which also has "age" and "gender", which ties in with physical activity. I have a table designed for male push-ups, etc.. This table has a field named "REPS" and each additional field is an age "17YR", "18YR", etc. When you cross reference these there is a score for how many REPS you have completed for how old you are and gender. I am trying to utilize a Macro or another method in which I can type how many REPS have been completed and it will auto-calculate based on your gender and age. Both gender and age are in the same form, but not the table. The tables I have created already break apart gender scores. Hope this is enough to at least start a conversation.

[ssanfu]

This sounds a lot like the post by killermonkey https://www.accessforums.net/program...elp-38626.html

What is your table structure and relationships?
Maybe post your dB?

[ttam73]

I ran a query to tie the individual information with the physical information. Based on this I have a form that displays both the individual information and the physical information. It is very similar, however I'm not too familiar with VBA and have aquired a sample database using Macros in which this works, but can't seem to duplicate the results after changing the names to the fields, tables, etc.

[ssanfu]

You should provide table names, field names, Queries, code and/or macros. Also examples of your data and the expected results. Maybe post your dB.

I never use macros, only VBA. So I won't be of any help. Sorry.