Sub Forms based on Queries?

[access7]

I'm having a lot of little issues with various items on my forms... a lot of my forms are based on queries, and sub forms alike. Is it a good / bad idea in other peoples experience to be basing my forms on queries or should they always be built from tables??

Any feedback / opinions on this matter would be greatly appreciated...

 

[Mr. B]

It is quite normal to use queries as the row source for forms. Using a query or a table as the row source should not be the cause of a problem unless the query becomes not up-datable due to the use of tables linked in the query in a way that causes the query to not allow updates. You can test this by opening your query in datasheet view and try to update a record. If you can update the record then the query is not your problem. If you cannot, then you will need to re-design your form and the record source.

Can you provide more detail as to the type of "little issues with various items on my forms" you are having?

 

[access7]

Hello, thank you for your reply... unfortunately there are may little problems.. one of which I have just posted about in a post on the Form forum called 'One thing fixed... another broken...' - that seems to be a trend I'm having! lol.

I have been having issues with saving records on the Contact history tab (through the SubFrm_Correspondence), and with the combo box (CboContact) on the same sub form - see other post for more info...

Another issue I appear to be having is with the 'Cancel' button on the form - I am wanting to be able to cancel an entry and therefore NOT save the record in the table - at the moment, the user is seeing the message 'Are you sure you want to cancel changes', pressing 'Yes/OK' and yet the record is still saving to the table. I need to look into this more.

I need to look into how to get my scroll bar working on the Contact History tab - I think as the form is locked the scroll bars don't work, but I will need users to be able to either scroll down to read text or ideally have the entries 'grow' according to how much text is written in the notes section.

I would also like an option to be able to delete contacts / archive them once they have been added - for example, if a person leaves a company and is no longer therefore a contact at that company.

I appreciate your time looking at my post and am glad that the queries shouldn't be an issue - they all appear to be editable when you run them so I'm not sure that's the problem. Good to know I don't have to go back to basics in design.

 

[Mr. B]

Perhaps when someone provides help for your other post you may start to find your problems. I would suggest that you try to just take one issue at a time and work through each one rather that looking at the entire series of issues.

 

[Galaxiom]

It is quite normal to use queries as the row source for forms.

I am being pedantic but really we should be using correct terminology here. Forms don't have a Row Source property. They have a Record Source.

Row Source is a property of Listboxes and Combos.

 

[Mr. B]

Sorry, my mistake. Should have taken my time instead of getting in a hurry.