Search results

Yes I did but unfortunately I didn't fully understand it. I'll try again to go through it to see if I can figure out what to do. In the meantime, I have attached a .gif to show what is happening

HI, By formatting it I meant just making the form look "pretty" - add colour, form headers, adjust font, etc. I added the event on the GotFocus but still having issues. The first picture is what I was seeing when I first opened the form (before adding the GotFocus) event Now the product...

My form stopped working again. It was working perfectly and all I did was format it and now everytime i open it the cboCategory parameter box pops up. What am I doing wrong?? 😩

With everyone's help and through trial and error (several trials and errors) I think I finally got it fixed. This is what I have for combo cboProduct. Control Source: ProductID Row source: as below SELECT tblProducts.ProductID, tblProducts.ProductName FROM tblProducts WHERE...

Ok...so I'm still getting a couple problems. I've tried both @MajP and @bob fitz methods and getting the same error message when I try to tab to a new record in the subform. A message box pops up which states You cannot add or change a record because a related record is required in table...

Yes...thank you. This seems to have solved my problem

This works...thank you so much

Hi. I did. Still didn't work.

If I open the subform frmMaterialRequisitionDtls alone, the combo boxes work. But when I open the frmMaterialRequisitions, the combo boxes do not work

I'm starting to think there is a problem with my Access program itself. Another database I have been using for over a year now, started giving trouble after an update in April.

I don't understand why but it's just not working. This time the Enter Parameter Value keeps popping up everytime I open the form

Good Morning, I would really appreciate assistance as I have been trying for over 2 weeks to get the relational combo boxes to work. I am trying to set up a Material Requisition DB. In the details section of the subform I tried to create a category combo box, which when a selection is made...

Thank you! When I check the version history I see there was an update on April 11th which is probably what caused the issue; and an update on April 25th. I just did the April 25th update hoping it was a bug fix but no luck. So I will try restoring the version before April 11th to see if that...

It wasn't a windows update, it was an Office 365 update

Hi. This is the main db I work in, the other one I am only now building it so I haven't noticed any issues...yet. I think as theDBguy said it is probably a system update issue. Is there a way to restore the previous version of access only?

Hi. Actually there was an update recently, can't remember the exact date, but it was either last week or week before.

Hello, I have a database that I have been using for the past 2 years which from this week has started giving some trouble. In the main form there are different categories which before I would use the filter button on the ribbon to narrow searches within a category. However, from this week...

I understand now. Thank you.

Ok. So instead of the multi-value fields I would then just create fields in my table named Client1, Client2, etc.? Same format for any other multi-value fields I currently have? So the C2 refers to Construction drawing Revision 2. The field DrawingType also refers to whether it is a...

Thank you all for your help. @CarlettoFed - i followed your query suggestions and the summary now works 😃 Thank you @Pat Hartman - I will definitely add an autonumber to the tblDrwgRegisterDetails. I forgot that sorting will result in C2 coming after C10. Unfortunately I cannot change the...