Search results

No problem, The fact that you did help me out is very much appreciated. Maybe I should have explained my problem better from the onset.. :) Cheers

Hi there, Is it possible that you could be a little clearer with your explanation. I am finding it rather difficult to follow the flow of your explanation. Cheers

Hi there Pat, It worked. Thanks alot, I do appreciate all the time and effort you have put into assisting me with my problem. Cheers

Hi there, Oh yes sorry, thats what I meant, I had the ownerID in the car table as a FK. But in terms of the underlying subform query, is there a way to get it to auto requery when I enter one piece of data as in the previous relationship, without having to move to lets say the previous record...

Hi there, Thanks for the response. I think it would be a little clearer if I describe my database to you. The database is for a car sales company, and their sales is associated with a certain car and the respective owner. I have a table in which exists data concerning certain cars, makes and...

Re: Hi, thanks for the response. Well, the fields on the main form are already populated based on the fact that their data source comes from a table, and the fields on the subform are related to the main form based on a primary key link. However, if I set the propertys of the subform fields...

Hi, This is the situation. I have a form in which I have embedded a subform. The subform pulls its contents from tables based on a query that is tied to one of the fields on the mainform. This is the issue that I have. When I enter lets say data into one of the fields on the subform(in...

Thank you for your assistance. I used your suggestion in conjunction with dbFailOnError and it worked. I do appreciate Cheers

Thanks Thanks alot for the tip, I will give it a shot and feedback on what happens.. Cheers

Hi there, I have an access database in which I am updating a table from a form using visual basic for access. I have got the update to work, however before the application appends the table, it asks a question "You are about to append a row" then an option for "yes or no" I have a custom...