Access One Time Field Entry

In the attached db, please open form "Start Up" Select "Elaine C" as the Analyst and "3" as Billing_ID. Then click on the button "Open Audit Entry."

The first tab in "Audit Entry" has the field [Audit_Start]. Please offer how I may enter the [Audit_Start] once, but then it is populated for all corresponding 10 rows for that Analyst and Billing_ID combination?

Thanks.
Start-Up-Form.mdb
tahirihAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Can you tell us what you've tried to do with this so far? Do you have an code examples of the things you've tried?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tahirihAuthor Commented:
What I have deon thus far is to create a query that aggregates all the fields, create a new table, then insert this as a subform. But there must be an easier manner...just do not know how to do so. In the table resulting from the query - I had the field [Audit Start].

The downfall with this method is that I have to update the query independent of the Source table to ensure that all information is captured.

Thanks.
0
tahirihAuthor Commented:
I also use the DoCmd.OpenQuery once the Audit_Start is entered to update the Subform table, but this does not fill in the specific fields needed.

And yes, I am still getting caught up to speed with VBA, but unfortunately I am not learning fast enough to get my project finished. I know there are ways of doing this without the VBA, but I am trying to gain as much speed as I can with VBA...

Thanks.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

tahirihAuthor Commented:
I can manage this by creating a Subform based on a Query that aggregates the values. Please let me know if you do not have the time to assist.

Generally, I piece together code from solutions, and work with this, but in this case, have not found any close to what I am looking for.

Thanks.
0
tahirihAuthor Commented:
Please offer your suggestions on how to close this question.

This database is above my skills, and as much effort as I have been putting into this trying to get caught up to speed, it is just not enough. I initially thought I could manage, but I really am biting off more than I chew. I can build databases, and have just a basic knowledge of SQL and VBA, but not extensive by any means.

I have consulted with colleagues, and we are all now aware of how far my skills can contribute, and I will proceed with this database at the level that I can. Time to fold my cards.

Please confirm how we can close this question. Also, I truly thank you for all your assistance to this point - you have no idea how wonderful you have been.
0
tahirihAuthor Commented:
I am going to go ahead and close this and award you points. I have been biting off more than I can chew, thinking that I can gain speed quickly, but not at this speed.

I have let my colleagues know my limitations, and they are supportive.

Thanks.
0
tahirihAuthor Commented:
Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.