Search results

Hi Uncle Gizmo believe it or not you have actually solved my problem. When you gave me the invoice example. By that I modified the database to create a form that has both sub form and parent form and it worked! Thank you so much I have attached a working database for those also having the same...

Hi I've just built subforms for my database. There is no main form that has any fields. So from your response I need to put fields in the main form (following an example of your invoice system) and the sub form will have addition details relating to the main form? So at the moment what I have...

Hi Yes no problems. The database has a parent form and sub form embedded which users enter information and it gets stored in the table via the sub form. The information entered in creates an ID. Sometimes users may not fill in some of the fields in the sub form because they don't have the...

Hi Uncle Gizmo I've attached a sample of the database. It's very simple as I am slowly learning the ropes. Update existing Document - That is the drop down box I have created so if the user wants to recall data in Documents table they select the ID and in theory the sub forms will populate...

Hi uncle gizmo thank you for your reply. Yes I do believe the sub form is embedded in the parent form. I had to capture 70 fields of data so creating a sub form was the only way I could think of to organise the data collection. There are multiple tabs of the sub form within the parent form. So...

Hi I hope someone will be able to assist as I've been a week trolling through websites trying to the find the answer. I'm going to have a breakdown and it's killing me I can't seem to get this to work At work I've built an access database which has a data table with a unique code ID for each...

Hi There just wanted to say hi to everyone and I hope to learn a lot from you lot! I'm stuck with a work database so will be posting my very first question. Thank you so much in advance to everyone to will help me!!1 really appreciate it