Hi,

I have a form that includes a toggle button. If the user clicks this toggle buttun then that means they have additional information to add to this particular policy and another form will open that allows them to add information to that form.

The problem is its an Continuous form and when i select the toggle button for one policy all the toggle buttons become selected.

Is there a way to prevent this from happening? Or do I have to make the form single. I was trying to prevent this since there are about 600 records but there is not much information

I have done something similar by placing code in the double-click event of a text box that opens a calendar form. You might be able to adapt this to your situation.

Yes, I would go Frank's route. A continues form will change the value of one control in ALL records if this control is unbound. You could bound it to a table field and then not have the problem, but that means a nother uneccisary field. If you don't care then do so, if not then go frank's route.
HTH
Good luck

You can use Frank suggestion which is perfectly good or you could simply change your toggle button to a regular command button.

What kind of code would I use? Command button i don't think would work.

Why would a command button not work? It looks similar to a toggle button and all its doing its openning a form?

What code do you have behind your toggle button to open the form now?

Let me try to explain what I have.

agent 05160 act # 582j4121 insured: beardsley cancel date 11/28/05
So lets say you have 660 items that look just like this except the policy and the cancel date is different.

i have a toggle button that says 3rdParty Notice. So if that particular policy has a 3rd party they would select the toggle button and a form would open. where they would enter the 3rd party information. Some may not have a 3rd party so the button would not be selected for that particular policy

The policy has a cancel date of 11/28 but say it gets paid so they now have to re-enter the database to reinstate the policy. They would then go in to another form that has all the above information but now and option to reinstate (haven't created this part yet)

I want the policies that had a 3rd party to stay selected so they can no that they when they reinstate the policy there was a 3rd party typed and that needs to be reinstated. Sometimes a policy doesn't get reinstated for 30 days and they not remember that they had a 3rd party. but if the toggle button is selected they will know.

I hope this makes since.

I think the major problem you are having is that you are trying to use one toggle button for two purposes: 1) to display whether or not there is a 3rd party involved, and 2) to enter the details of that 3rd party. I think you're going to find that in general using one anything for two purposes leads to unnecessary complications.

Upon rereading your original post, you might be better off with the traditional form view, one record at a time, with a Find a record on my form blah blah blah combo box to allow the users to navigate quickly to specific records.



Edited by: fkegley on Thu Nov 17 14:28:26 EST 2005.

Edited by: fkegley on Thu Nov 17 14:34:57 EST 2005.

I am going another route all together but thanks.

I do have another question. Can I have a report or form open every 10 days by tracking a date in a particular field.

so it the cancel date was 11/18 and it still has not been paid on 11/28 I want a report to become available showing all the polices that have a 11/18 cancel date so be shown. this would have to happen everyday. so on 11/29 anything witha a 11/19 date

I am going another route all together but thanks.

I do have another question. Can I have a report or form open every 10 days by tracking a date in a particular field.

so it the cancel date was 11/18 and it still has not been paid on 11/28 I want a report to become available showing all the polices that have a 11/18 cancel date so be shown. this would have to happen everyday. so on 11/29 anything witha a 11/19 dat

Yes, I think so. An AutoExec macro could be developed to open the report.

Develop a query that fetches the needed data for the report. You'll need to use the DateAdd function in the Criteria: cell of the relevant date field to fetch the records

Between Date() And DateAdd( ' I can't do from memory but it is in the help files.

Then build a report on the query.

Develop a macro named AutoExec, exactly that. Have it open the report in preview.

An AutoExec macro runs every time the database is opened.

And, of course, other ways could be developed to open the report as well.

Edited by: fkegley on Thu Nov 17 15:57:58 EST 2005.

Do I need to put something in the cancel date criteria to it knows to calculate based of of this field.

So if the cancel date 11/18 and its is only nine days past don't show this policy. only 10 days past the actually cancel date and is has not been reinstated.

Yes, in my last post I referred to the relevant date field. That would be the cancel date.

I showed it with a Between operator that would not be correct. You would want the cancel date to be today's date plus 10.

I believe DateAdd can do this:

Criteria: DateAdd("d",Date(),10)

I may have it garbled as to syntax, so you'll need to look it up in the help files.

Edited by: fkegley on Thu Nov 17 16:22:41 EST 2005.