Search results

  1. S

    Writing values from a cascaded combo box

    Hey John, Got it, I missed the 'Allow Edits' property on the sub form. I think I am good now, will play with this some more, and if I need any more help I will be asking you again. I dont know if I can thank you enough for your help, but I did learn quite a bit from you (and still trying to...
  2. S

    Writing values from a cascaded combo box

    Hey John Thanks again, I used the code you gave me, and it works like a charm, 1. For the amend/delete functionality, I made the changes on my DB, but I have an issue with the checkbox. When I click it on the form, it does not check it (it kinda greys it out or puts like a white highlight on...
  3. S

    Writing values from a cascaded combo box

    Hey John Thanks for the quick response. I am clear on question 2 and 3, but I guess I did not explain myself well on question 1. I meant to ask, that I have an existing query called 'InvoiceDetails_Query' so instead of creating one more called 'QRY_InvItem', cant I instead use the existing...
  4. S

    Writing values from a cascaded combo box

    Thank you once again. I think I am very close to completion, just trying to do a clean up. Three more questions for you. 1. I noticed you added two queries, QRY_InvItem. and QRY_ItemAdd I know we need the ItemAdd query, but do I need the QRY_InvItem, when I already have a...
  5. S

    Writing values from a cascaded combo box

    Hey I noticed on the example that you did for me, that you have linked the invoiceHeader with the subform quite differently, and I am trying to understand it, if you can help. 1. The way I did it was to create the Invoice form, with each record being identified with the invoice number, and I...
  6. S

    Writing values from a cascaded combo box

    Great! Thank you so very much, I could not have moved ahead without your help I am going to try and complete the project, will ask if any more issues Thanks once again
  7. S

    Writing values from a cascaded combo box

    Hello John Thanks again for your prompt reply. I will disable the messages as you directed. But I wanted to check with you, if I am doing anything wrong because of which I am getting the said message, or is it just because I am writing to the InvoiceDetails Table. I will complete the other...
  8. S

    Writing values from a cascaded combo box

    Hello John I cannot thank you enough. I was unaware of this limitation, and probably would never have figured this out without your help. I see what you have done, and I like your work around But I had a question, everytime I try to add an item to the invoice, it brings up a warning...
  9. S

    Writing values from a cascaded combo box

    Hello John Thanks so much for your reply I am attempting to attach my file with this post The combo boxes in question are the ID_CategoryID and ID_ProductID and they are on the form titled 'Invoice Details Sub Form'
  10. S

    Writing values from a cascaded combo box

    Hello Friends I am a new member I have been working on an access project for months, and I am stuck on one problem and I desperately need help, hence this email I have a pair of combo boxes which I am cascading, using the cascading combo boxes principle, however I have one problem After...
Back
Top Bottom