Access 2010 form question

[Trilback]

I have a warranty repair db that I use on a daily bases. I use it to keep track of the bad computers I run diagnotics on and what there problem is. The problem I have is I want 2 sub forms. One that allows me to add new common issues to my issue table and another form to add manual issues. I fill out my warranty form which gets inputted to my warranty table. The Issues come from the issue table and get stored in my warranty table under the IssueSel field. When I add a new common issue it gets added to the Issue table to the Issue1 field but I want it copied to the IssueSel field in my warranty table to that I can requery my Combo box with the current Issue I added. My "manual issues" I wanted a form so I have more room to see what I typed before it gets put into the IssueSel field and shows up in my combobox and gets requery As you see attached is my database of my front end and back end of it. Right now the tables are linked to C:\Warranty Repair_backend.accdb for testing as I made a backup of it. I am by far not a programmer so I used example codes from the web and made my db work.

 

[Geotch]

Re: Access 2010 forum question

There is a setting in the combo box properties that does what you want.

In the properties of the combo box go to the Data tab, then Allow Value List Edit. Change that from no to yes. You then have to choose the List Items Edit Form. Choose the form. Now when you enter a new Issue, you'll get prompted to add another Issue. It will take you to the first record so you'll have to add buttons to enter new, edit, etc. Once you add it to the Issues form, it will requery itself and be available in the drop down box when you return to the Warranty Repair form. You'll also notice an option after clicking on the drop down to go directly to the Issue form.

I made all these changes to the Issue drop down box on the Warranty form as an example. Try it out and let me know if you have any questions. Not sure if that answers all of your issues.

 

[Mihail]

Re: Access 2010 forum question

I can't open your DB because I use Access 2007 but, from Geo's description, I think I understand your issue.
Another approach can be to change the Limit To List property to No. (Property Sheet, one row before Allow Value List Edit).
Then, in Not In List event you can set a flag that say you that this is a manually enter (unlike a common issue that should be set as default).
This will allow you to query for issues grouped on "common issues" and/or "specific issues"

 

[Trilback]

Re: Access 2010 forum question

There is a setting in the combo box properties that does what you want.

In the properties of the combo box go to the Data tab, then Allow Value List Edit. Change that from no to yes. You then have to choose the List Items Edit Form. Choose the form. Now when you enter a new Issue, you'll get prompted to add another Issue. It will take you to the first record so you'll have to add buttons to enter new, edit, etc. Once you add it to the Issues form, it will requery itself and be available in the drop down box when you return to the Warranty Repair form. You'll also notice an option after clicking on the drop down to go directly to the Issue form.

I made all these changes to the Issue drop down box on the Warranty form as an example. Try it out and let me know if you have any questions. Not sure if that answers all of your issues.

How come I can't add a new record now? I have a button that creates a new record on load.

DoCmd.GoToRecord , , acNewRec

 

[Trilback]

Re: Access 2010 forum question

There is a setting in the combo box properties that does what you want.

In the properties of the combo box go to the Data tab, then Allow Value List Edit. Change that from no to yes. You then have to choose the List Items Edit Form. Choose the form. Now when you enter a new Issue, you'll get prompted to add another Issue. It will take you to the first record so you'll have to add buttons to enter new, edit, etc. Once you add it to the Issues form, it will requery itself and be available in the drop down box when you return to the Warranty Repair form. You'll also notice an option after clicking on the drop down to go directly to the Issue form.

I made all these changes to the Issue drop down box on the Warranty form as an example. Try it out and let me know if you have any questions. Not sure if that answers all of your issues.

I did what you told me too but once I added the common issue and close the Issue form that is did not requery right cuz I had select test me from the list when it should have come up once I added it.

 

[Geotch]

Try it in the database I uploaded and make sure that works. Do everything from the combo box. Don't open the issue form until the combo box prompts you to.

 

[Trilback]

Try it in the database I uploaded and make sure that works. Do everything from the combo box. Don't open the issue form until the combo box prompts you to.

Hmm cool way to do it. The problem is the one you gave me it did ask "The text you entered isn't an item in the list" and it did bring up the issue form but never showed it. Also now that I think about it sometimes I want to use a common issue but add extra text to it. I have the combobox set to Limit to list so that I can edit the text I want for the specific warranty record I am doing. I would rather have 2 buttons to open a form (2 different forms is fine) One, to add common issue and two, to add manual issue. The reason behind issue a form is so i can add more text to my issuesel and even use carriage return in my issues like this.

Battery test failed
Error Code: 1234567
replacment suggested

 

[Geotch]

it did bring up the issue form but never showed it

Yes, that's one of the issues with it. The user has to retype it. Maybe someone has some VBA that can fix that.

 

[Trilback]

Yes, that's one of the issues with it. The user has to retype it. Maybe someone has some VBA that can fix that.

I know what needs to happen I just dunno how to do it. When I had inputbox for adding common issue I used recordsets to pass the common issue from the inputbox to the Issue1 field in the Issue table then copied it to the IssueSel field in my warranty table and when I requery the IssueBox (ComboBox) it showed up without me having to select it. What I want now is to do the same thing but instead of a input box I want to pass the info from the Issue1 box on my form to the IssueBox which is my IssueSel field in my warranty table.