Combo Box

[Uschi via AccessMonster.com]

I have a form based on a table that keeps the entire ownership history of a
homeowners association. The current owner of the property is shown with a
checkmark in the checkbox.

At this time the user clicks on the FIND command, enters the space no and
then clicks FIND NEXT until the checkmark appears for that space (records go
back to 1986).

Problem: The users (all retired) are having problems with the FIND command.
Most of it has to do with not paying attention. Clicking around the form
also doesn't help when there is more than one ownership that needs to be
updated. What do they do with the REPLACE? Don't even go there.

Question: Is it possible to create a field (FIND CURRENT SPACE NO) where the
user can just type in the space no, press Enter and the current record
appears on the form? I have not been successful creating a combo box for this
purpose.

Your help will be appreciated.
Thank you

 

[Daryl S]

Uschi -

There are a few approaches to this depending on the needs of your users.

If you users only need to see the current owner, then change the
recordsource of your form from the table to a query based on the table. In
this query, you can restrict to only show the records where the current owner
checkbox is true.

If your users always need to see all the records, then change the
recordsource to a query based on the table, but sorted by the current owner
checkbox so that it always appears first by default.

If you users only occasionally need to see the remaining history, but always
need to see the current record, then I would add a checkbox on the form with
a label like "Show only current record". Make this unbound checkbox default
to True. Then set your recordsource depending on the status of the checkbox.
The default would be to only show the current owners, but they could see all
owners if they unchecked the box.

Hope that helps!

 

[Uschi via AccessMonster.com]

Daryl S.,

Thank you for responding.

I cannot change the record source for this form. The form is based on one
table. The user needs to find the current record for the space in order to
enter information to close out that current record and then add a new record.
There is a check box to indicate the current owner. Also, reports are based
on on that record.

I should have explained that form was for adding new records and not just for
viewing. I apologize for not making this clear.

Uschi

Uschi -

There are a few approaches to this depending on the needs of your users.

If you users only need to see the current owner, then change the
recordsource of your form from the table to a query based on the table. In
this query, you can restrict to only show the records where the current owner
checkbox is true.

If your users always need to see all the records, then change the
recordsource to a query based on the table, but sorted by the current owner
checkbox so that it always appears first by default.

If you users only occasionally need to see the remaining history, but always
need to see the current record, then I would add a checkbox on the form with
a label like "Show only current record". Make this unbound checkbox default
to True. Then set your recordsource depending on the status of the checkbox.
The default would be to only show the current owners, but they could see all
owners if they unchecked the box.

Hope that helps!

I have a form based on a table that keeps the entire ownership history of a
homeowners association. The current owner of the property is shown with a

[quoted text clipped - 16 lines]

Your help will be appreciated.
Thank you

 

[Daryl S]

Uschi -

You can add a filter to the form that only selects the current record (those
with the checkbox). You can make that the default, and then if the user
closes out the record, you can turn the filter off.

--
Daryl S

Daryl S.,

Thank you for responding.

I cannot change the record source for this form. The form is based on one
table. The user needs to find the current record for the space in order to
enter information to close out that current record and then add a new record.
There is a check box to indicate the current owner. Also, reports are based
on on that record.

I should have explained that form was for adding new records and not just for
viewing. I apologize for not making this clear.

Uschi

Uschi -

There are a few approaches to this depending on the needs of your users.

If you users only need to see the current owner, then change the
recordsource of your form from the table to a query based on the table. In
this query, you can restrict to only show the records where the current owner
checkbox is true.

If your users always need to see all the records, then change the
recordsource to a query based on the table, but sorted by the current owner
checkbox so that it always appears first by default.

If you users only occasionally need to see the remaining history, but always
need to see the current record, then I would add a checkbox on the form with
a label like "Show only current record". Make this unbound checkbox default
to True. Then set your recordsource depending on the status of the checkbox.
The default would be to only show the current owners, but they could see all
owners if they unchecked the box.

Hope that helps!

I have a form based on a table that keeps the entire ownership history of a
homeowners association. The current owner of the property is shown with a

[quoted text clipped - 16 lines]

Your help will be appreciated.
Thank you

--



.