Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Welcome to the skill header Forums. You can ask questions, get help, or help other members out. Join our Forum for free.
Notifications
Clear all
Nov 16, 2024 5:37 pm
I have gone over this for the past 6 hours and keep hitting a brick wall. I set the New Order form, using the YT tutorial of course....at 21 mins and 58 seconds. My form fields are all blank and when selecting customer, all I get is a chime sound. You show default information in your video, such as Orderid = new and OrderDT shows the default date as set up in properties. Any ideas on what to try next?
TYT, Fred
3 Replies
Nov 16, 2024 11:15 pm
Eureka! afte3r another two hours, I worked it out. Not even sure what I did except I created new controls for each field versus adding from existing table fields menu. Onto orders subform....
Nov 17, 2024 10:41 pm
Hi there, I have showed you the simplest way, killed two birds with one stone. It means while selecting the customer from the drop down, data has already been fetched and I simply used the column number to get the shipping address. On the other hand, to inherit shipping address from the customer table, there is another way to use DLookup.
Simply make sure 2 things:
- Adding Shipping Address column into the combo box query
- Reference of the right column number (0 from the 1st column)
Nov 18, 2024 4:50 am
Thank you Ursh, I see that clearly. I had messed up my coding so bad I could not figure what was happening. Fixed that one, found another coding problem I am having trouble with and need your guidance. Will post in a new thread.
