How to Create Subform links to Main Form: MS Access

[slyowusu]

Thanks Austin. Life saver. Another question please. How do I set timer to automatically close a form if not used for say 5 mins?

[jimmyk]

Do you have a video on this?  I created a query for this purpose and then created a form.  Do I now create a macro?  Sorry with all the questions, I have just started learning about 2013 MS access and have been trying to figure this part out for the last number of days.  I am still new to access but really love it and was able to create a navigation and sub forms due to your videos.

[llexlopes]

Wow... Nice. Works like a charm (Access 2013)!!!

[agg]

Do you have first created relationship b/w tbl_customer and tbl_customer type?

[smorisch]

As always.. great tutorial! Thank you so much, you've helped me tremendously.. Now, I need to know how to take the subform list items, select one of the items and have it open up in another form. Something like - My forms - Master = Customer, Child = Ship to Locations, When I click on a location in the Child Form, I'd like a Work Order form to open up with their information auto-filled (Name, Address, Parent Account number, etc). . 

[khryztaldelossantos]

hi i tried doin whats in your video but after i typed the selected field and click next on your video tim is 2:39 the bullet choose from a list is unclickable on mine i dont know why but i only have the "define my own" option. do you know by any chance how to fix it

[slyowusu]

Hello Austin. Thanks for your helpful advice & videos. Question. I have a main form (orders) with a subform (customers). When I open the main form to enter an order, I have done the code to populate the specific customer ID from where I add the order details. What I cannot do is get the subform (customers) to show basic details (name, address) relevant to that Customer ID. So that when entering orders you can see the customer details above. Can you help please? Thanks.

[jimmyk]

Hi Austin

I finally figured out what I wanted to do with a little bit of luck but accidentally deleted the table as I was experimenting.  I believe I am missing one small step and please let me know if you can assist.
 
I created a database table of my clients in 2013 access and one of the fields was "client name".  I then created the database table into a DATASHEET FORM.
 
I created a second database table (description) with fields such as address, phone number, email, etc.  I then created this into an AUTO FORM.
 
I linked the form with the macro below so that when I clicked onto the "client name" in the datasheet DATASHEET FORM,   it would open up the AUTO FORM and I could update accordingly.  When I originally figured it out I clicked on a "client name" further down the list it would open up the auto form and reflect that customer ID (for example CustomerID 48.
 
When I re-created the set up, as I deleted one of the forms, I can click on the "client name" it will open up the AUTO FORM and I can still update accordingly.  However, if I have for example 100 clients, and I choose one lower down the list the customerID reflected will be the next in sequential order instead of the CustomerID as per the number associated on the DATASHEET FORM.  In other words  if there are 100 clients and I open up client name (CustomerID 48) first it will reflect CustomerID 1 and not CustomerID 48.
 
I am not sure if it has something to do with ID auto number for both the DATASHEET FORM and AUTO FORM
 
Below is the type of argument I am using

Form Name     Conditions
View                Form
Where Condition
Data Mode        Edit
Window Mode   Dialog

[AbiSarav]

Thankyou very much for this video. I was trying all day to link my subform to my main form. It turns out I was doing it completely wrong.

[chantelbailey]

Heyy Mr.Austin can u assist me please.. I'm creating a prototype for a restaurant and I'd like for each item selected to be transferred to the receipt do I create a subgroup?

[somseiharath]

Thanks for this video, I have Ms Access 2013 and I try & try to do the same like you, but the selected item not link to sub form automatically like you shows in the video, Please tell me why?

[deborahtjokrotekno]

Hi Austin, I have contacted you before. I thought I have solved my problem to search customer records by city with combo box. I find this video of yours so I tried to use this approach. It works wonderfully but now what to do if I want to print preview the result? Any hint? Thanks

[brandplays_]

I forgot to link the subform to the main form, after the subform is made, how can I connect it to the main form, can you tell me please?

[deborahtjokrotekno]

Hi Austin, one more question. The link between main form and subform is the customer type. Is it possible to add another choice, for example Search "active" customer records by city. Thank you.

[erroldelossantos]

Hi Mr. Austin, can you help me on how to make a form with two parts, on the upper part, there will have the doc number, doc date and narration...and on the lower part it will show one database view with 4 columns; account column, debit column, credit column, and description column... in short i would like to make journal entry form using access 2007... Is it possible to do it using access 2007..? thanks a lot....

[mccoffenberry]

Can you explain- how is the ID generated? Is it already defined and linked to the Customer Type- or is it auto-generated?

[dhungchauful]

Please help. I don't know why the total in my invoice is shown blank, & also the total in my reports with the cursor flashing on its field, until I  click on it, its total pops up. Any ideas?

[AmitPandey-ijtc]

Can you please share the link to download this database. Thanks...!

[jimmyk]

Thanks for the awesome videos.  I have created a spread sheet with all my clients and part of the spread sheet involves updating documents as I receive them.  I created a drop down menu for these specific cells.  Instead of it being one huge wide spreadsheet is it possible to create another form for these specific cells?  So only when I need to update the document for these specific cells I can access the client name or ID (for example) and it brings up this section and I can update it accordingly and it saves the update for each individual client as I update?  Thank you

[vbaaccess]

Hello Austin,
When you open the main form the combobox is blank and the subform has some records. What would you recommend to fix it?
Thank you in advance.