Checkbox

[alikojan]

Hi everyone, I need HELP, plese help me if it's possible.
In ms access i have 2 forms "Issues" & "Closed".
In "Issues" I have checkbox, when clicking on checkbox I need the record to be mooved to "Closed" form.
How can I do this.

Thanks in advance for response.

 

[CBrighton]

I assume these are 2 forms bound to different tables / queries?

If so you don't change which form it is displayed on, you change where the record itself is (e.g. append it into a new table and delete it from the old one).

 

[alikojan]

Yes, but how I need to do it?

 

[CBrighton]

Hard to say, given that I don't know if we are talking about 2 completely different tables or 2 queries with slightly different criteria which are based on the same table, etc.

It could be that you only need to set a field like "IssueStatus" to "Closed" and requery the forms (which an update query can do for you), or it may be that you need to move the record into a whole new table (in which case you will need an append query to copy it to the 2nd table followed by a delete query to remove it from the 1st).

It depends how you store the data and what the difference is between the recordsource of the two forms.

Let us know what the difference is between the record source of the 2 forms and we'll be able to help more.

 

[alikojan]

In my Issues form I have Customer, Machine, Date, Issue, Status(combo-waiting, monitoring, closed), and check box. When I give the status "closed" to record i want to click on ckbox and i need my record to be moved to form "Closed" and for me it doesn't matter there will be 2 tables or just 1. Please show me easiest way as You wish.

Thanks a lot.

 

[CBrighton]

The form doesn't matter, except to identify what record source we are talking about.

I don't need to know what controls you have on the form, I need to know the data structure to advise you how to alter the data.

I need to know what tables / queries the forms are bound to. If they are queries I need to know what tables those queries use.

I need to know how Access identifies whether a record should be displayed on one form rather than the other. Only when I know how the form knows which records should be displayed can I tell you how to display a record on a specific form.

 

[alikojan]

I am writing in the form by myself, it is very simple db, if it is possible I can send it to you and there is no any query in my db

 

[CBrighton]

You can attach it here (zip it first if you don't have enough posts to upload a database), however please use .mdb rather than .accdb as this PC only has Office 2003.

It goes without saying but ensure no sensitive data is in the database before uploading, and a sample (just the tables, forms & querries related to this problem and some dummy records) is better than a whole database.

 

[alikojan]

I've attached the mdb file

Thanks a lot