Listbox record to Dashboard (1 Viewer)

[Donovansmth]

Hello,

I have a dashboard that everyone uses, on the dashboard there is a project sub form that shows project detail fields.
Attached to the sub form is a search button that opens a project Listbox which shows all the projects in the database.
I’m trying to select a record in the Listbox, and move the project ID to the dashboard to repopulate the initial project fields.

I was about to run a query that pulls the project number of the project list record, but I can’t put that number in the text field of the first form to update the project shown on the dashboard.

 

[MajP]

Not sure I fully understand. But I think you want to pop up a listbox, select a value from the listbox, close the pop up form and return that value to the calling form.
if so

Access VBA - Prompt a form and return value to caller

Hi, A common feature my apps require is getting a user selected value from a universal popup form and using that value in a sub. I have been lousely designing such forms where they are passed an input (open args) and based on that arg, the form passes to the next function in the stack. Heres a...

www.access-programmers.co.uk

 

[Donovansmth]

Yes exactly that, thank you for the referral

 

[MajP]

Yes exactly that, thank you for the referral

There are many different ways to do this. I find this an easy way and makes my solutions loosely coupled. By that you do not want to hardwire your pop up to only work with one form control. You can make it generic and call from many controls and many forms.