Search results

I hope you don't mind me using the class module from the example you created? I have two fields on my form, one for pickup and another fro deliver: both use same query to get the address. I can use your code for pickup with the lines of code below but don't know how include the delivery field...

Thank you for the link. It gave me idea where I am going wrong. I am working my way through the code and will will be back if stuck again.

I am trying to implement method from the link below for my needs but it doesn't seem to work. :banghead: I would appreciate if you could help me find out where i am going wrong. Form: frmMainForm Combobox: PickupID Event: On Change https://www.accessforums.net/showthread.php?t=48811

Finally got time today to have another look at the DB to see why it did not work with the current setup. Started with checking the relationship between the tables and that is where the issue was. Basically with the form and subfrom that I had, I was trying to enter data to the oo(many) part of...

Hi Arnelgp. Could you possibly help with the issue I am having with forms on my DB please? https://www.access-programmers.co.uk/forums/showthread.php?t=307636 Thank you.

This is a test DB and names will be changed once i figure out how to fix this issue. Subform can not be filled first as not always there will be data entered there. Somewhere I read a suggestion to delete subform data source object and have the main form event to open it after. I don't have...

I will try the tab option, thank you.

Could you suggest what would be bet way to do it based on the example i attached.?

I think it makes more sense to have all that on one form as it is part of same "load", rather opening different forms to enter bits of information separately.

I have a main form with one datasheet subform. There are fields from multiple tables on that form and I can enter or choose data there fine. When I try to enter data in to subfrom it gives me "You can't a assign value to this object" error. I searched the forum and it seems to do something...

I will surely note that down for future reference.

Thank you very much. So it I need to set the Column Width to 0";2" or 0";1" :banghead:

Still no luck to get the combobox to display the location instead of the ID only. I am using a query that concatenates the address, city and stat in to one string, as a row source. I apologies if my questions sound dumb, i just started learning

Attached the file I was referring to.

I got it, thank you. One more question regarding the frmFromTo from the file attached. The source for the From and To is a query that concatenates few field. When choosing the location it shows ID along with the address, but when selected it displays the ID only. How can i configure it to...

Yes, I played with it over weekend: it adds values from"FromLocatoin" field but the "ToLocatoin" to the tblLocation table. That basically means that I would not be able to query by From location of the tblLocation. Is there any way around it except creating another Location table?

Did you have a chance to look at the example?

I have uploaded the file. Again thank you for all the help.

I created locations first and then then added Item in tblFromTo with dates and locations. After that it should show in expanded tblLocation the Id of from the tblFromTo with the item and dates?

pbaldy and theDBguy thank you for you quick reply. I did that before posting here but the data I entered in the tblFromTo table did not appear on the linked tables. Maybe I've done something wrong somewhere else?