Recent content by vixinho

Hello Access world. I have a database with multiple tables. I have created a query to provide specific data from various tables. I have then created a report from the query. Which code can I use to filter my report on key-up? Or can I use a continuous form from the query as a subform for my...

Hello, I am back again yet with a new challenge. I have a form which I use to feed data to two related tables. One table receives data direct from textboxes while the other receives from a list box. Is the any VBA code can I use for a searchbox to give details in textboxes and list box according...

Sure, Let me revert to the working code and study on your code some other time. Thank you bro

Hello @cheekybuddha when using this code you edited it gives an error message saying you cannot add or change a record because a related record is required in table tblInvoice. It however save data to the mother table but doesn't to the InvoiceJoin table. Kindly guide me on this.

Le Let me try your mentioned preference although the first one already worked. I am really humbled. You may not know how much you have helped me coz I have been really struggling to figure out the error

Wauh Wauh Wauh! This solved my problem which I have been trying to solve alone for over a month now. Thank you very very much @cheekybuddha What could I have done without you. Now I can proceed with my coding to enhance other functionalities. I will be back here for your help again in case I...

Hi Cheeky, the only part I omitted is End Sub

Hi, I have the following code to feed data to two related tables. The mother table is tblInvoice and the child is invoicejoin, Therefore I cant feed data to the child before feeding to the mother table. The mother table is to be fed with data from specific textboxes in my form while the child...