Displaying new subforms in real time.

[sgp667]

Hi guys I am working on a CRM db, and I stuck on the forms of it.


Here is the issue, while receiving a call from a customer db user might need to log multiple issues that are not related to one another, and more importantly these issues might have unique variables for example:

During a call a customer complains about the service he is receiving BUT during the same call customer requests to receive an estimate for a different service
-In a complain our variables would be service date, complain type, etc.
-In an estimate our variables would be job size, service type, frequency of service etc.



As you can see I cannot treat complains and estimate requests as new records in the same table because their fields will not match.
They way I am hoping to solve this problem is by having a subforms show up in a list like records in table embedded in a form.
I guess this would require a button similar to new record button but instead when clicked a new subform appears on the screen, hopefully in the same window.

I should not that I don't know how to code in VB SQL or Macros but I know enough about them to embed there wherever needed.

[June7]

Maybe have subforms for complaints and estimates on pages of a tab control.

[sgp667]

That does sound like a good idea.

So is there a way to control what tabs are aviable in TabNavigation based on a Query, like in ComboBox?

I dont know if this is a good idea but I would add in main form a " New Concern" button that would create new Tab.
To do that I would need a table that would connect Call to concerns( fields would be something like: Call ID, Concern ID, Concern Type). Based on Concern Type different subform would show under each tab, and based on Concern ID appropriate record from Compains, Estimates Etc. Table would be displayed in the subform( im assuming that user will later go back to what he/she recorded).

I am not sure if this is a clear explanation, maybe you have a simpler or mor efficient solution.
So again is there a way to control what tabs are aviable in TabNavigation based on a Query, like in ComboBox?

[June7]

Code can control visibility of tab control pages.

Don't understand your idea for a 'New Concern' button. Why would that create a new tab? Creating a new tab requires modifying form design.

Why would a different subform show under each tab?

I don't understand your data structure. If you want to provide db for analysis, follow instructions at bottom of my post.

[sgp667]

My db currently doesn't have the components for that yet but, in couple of that I will add them so that I can explain this better