Form Mystery Record 159

[justphilip2003]

I have a development Form Gallery that I was using to update a Memo field for CarvingNR 159 and made an unknown key stroke and the form disappeared. In the table Adv_Carving_Table the data has IDCarv = 216 and all data appears to be good and the external picture folder is okay also; since I was inputting notes in the memo field, I wonder if there could be a hidden code there causing this effect, but how to search it out. I can view any carving number before or after # 159 with perfect results and view the pictures. When I choose # 159 the Form disappears and is replaced with a blank data sheet/design (?) view. Itried the compression repair, exit Access 2010 and returned, imported the production version of Form Gallery and rebooted my PC all to no good effect on this weird problem. Open for any suggestions. TIA Phil

[June7]

Want to provide db with this issue for analysis?

[justphilip2003]

I would love for a professional to see this problem but the compressed db is 1,132 KB and the external picture folder is 317 MB (uncompressed). I to not have an on-line storage place to upload to.
I tried another idea, I removed the memo note I was updating - no good! Can we try a few fixes before uploading somewhere, it would be nice to be able to pare down the problem. TIA Phil

[justphilip2003]

Things are getting stranger! I brought up the productiondb that I haven't touch since placing it in production (Thursday, ‎May ‎9, ‎2013, ‏‎5:11:12 PM). I am experiencingthe same phenomena there also. It seems to me that the only commonalitiesare my PC and Access 2010. Same thing with the older production db. Suggestions? TIA Phil

[RuralGuy]

How about just importing the table in question into a new db and then zip it up and see if it will post?

[June7]

1,132 kb is small db. 2mb zip is allowed as attachment to post. Can probably do without the images.

[justphilip2003]

The ZIP database Gallery159 is attached. I suspect you will not be able to duplicate the problem, if that is so, I think I will need to reload office 2010! Ouch! To duplicate problem, load Form Gallery and key in 159 in the ComboBox. June7, I know you won't like the Picture Control, truth is, I could not come up with workable code! TIA Phil

[RuralGuy]

Needless to say I cannot find anything wrong with your Adv_Carving_Table. I was using ac2007 at the time. I was wondering why you chose to find the record with a Wild Card lookup in the Query instead of just going to the record in the AfterUpdate event of the ComboBox. Then no Requery would be necessary and your problem would probably go away.

[justphilip2003]

Adv_Carving_tableis included in the uploaded zipped Gallery159 db in previous pos. TIA Phil

[RuralGuy]

I know, and I see nothing wrong with it.

[justphilip2003]

Thanks for your response. The initial concept for the Form included displaying data from multiple tables including a Picture Table, (currently only two Tables are accessed) and I did not know any other way to associate multiple Tables to a Form. Still learning some basics as I go, LOL! TIA Phil

[RuralGuy]

As you probably know, a query looks just like a table to a form and a query can join more than one table in the recordset if they have a relationship. Use the ComboBox wizard and add a control to your form and select option #3 and see how it works.

[justphilip2003]

I'm sorry but I do no understand your instruction. Do you mean select combBox Wizard Category #3 "Form Operations" if so what action #1 "Apply Form Filter" or #6 "Refresh Form Data"? TIA Phil

[RuralGuy]

The ComboBox wizard will allow you to place a new ComboBox on your form. When it does it starts asking questions and the first one has three possible answers. Select answer #3 and complete the wizard. Then try that ComboBox and see if it does what you need.

[June7]

I also do not have any problem selecting #159 and viewing record.

If you must use mdb file then the Image control will not have ControlSource property and the Attachment field type is not available and then I think VBA is the only way to dynamically display images.

Cannot use single form to enter/edit data into multiple tables. Do you want to be able to edit data on this form? What is purpose of unbound Path and Message textboxes?