Popup form guidance

[Squiddley1957]

I want to add a facility for users to see associated records (from a related many to many arrangement) on a popup form. Creating the form and syncing should not be a problem but I want the Open Popup Form button on the main form to display the number of records on the popup.

Any guidance would be appreciated.

[Squiddley1957]

Further: I'm presuming that, in order to count the number of records on the popup, the popup must be open. This being the case the form visible property could be set to false and the Open Form button merely toggle the visible property? Would this work and/or is there a more elegant alternative?

[twinnyfo]

Squiddley1957,

The Form does not need to be open, but you do need to know the RecordSource for that pop up form. Once you know that, you can count the records.

Hope that hepps.

[Squiddley1957]

The recordsource will be a query. What form would the coding take?

[twinnyfo]

Let’s say you have a text box on your currently open form, named txtRecordCount. It’s record source would be =DCount("*", "YourQueryName") (Note: you will have to straighten out the quotes on that, as my iPad automatically makes smart quotes. If you have a SQL string for your query, you can use that string instead of the Query Name.

Hope this hepps!

[NeoPa]

As Twinny says, it's not absolutely necessary to have the form open. However, it's generally a good idea if it doesn't complicate life too much. It's easy to add a TextBox onto a Form (Header or Footer Section) which counts the records. That way you count a recordset that's already open. You also don't need to worry about the recordset being complicated by any filtering as you're counting what's already there - predefined.

[Squiddley1957]

Hello Neopa

I have limited knowledge of coding. When you say that you count a recordset that is already open - is this still the case if the query (underlying the popup) is not running? Is it sufficient that the query exists?

[twinnyfo]

If the query exists, using =DCount("*", "YourQueryName") should give the number of records returned in that query.

[Squiddley1957]

Thanks both to twinnyfo and NeoPa

[NeoPa]

Squiddley1957:
is this still the case if the query (underlying the popup) is not running? Is it sufficient that the query exists?

No. However, if the popup is open then the query will be running. If you have a bound Form then the RecordSource is automatically opened whenever the Form is.

If you have a bound Form that's open then I'd advise using that. If it's either not open or not bound then the recordset isn't available and using DCount() is perfectly sensible.