Solved Tabbed Form

[sctb0825]

I have a tabbed form. see screenshot img 1

My contact log in in a seperate table. see screenshot img 2

On my contact log table the agent cd and contact reason are lookup boxes (design view img 3)

Originally I had created a seperate form for contact log input img 4

What I would like is to have it all look like img 5 with the datasheet view inside the tab and fillable from that location.

I tried just adding the fields there but I am not doing something right cause I get an error saying the row is not committed.

Can someone give me some direction on this matter or a better way to do it.?

 

[theDBguy]

Hi. It might be better if you could post a sample db with test data.

 

[sctb0825]

Hi. It might be better if you could post a sample db with test data.

 

[sctb0825]

I read somewhere that too many querys was a bad practice also truth or fantacy

 

[June7]

It's bad practice to have multiple queries that pull same data with only difference of static filter criteria.

Pat, why would prefixes on field names interfere with intellisense?

 

[sctb0825]

understood any query that uses same table I just expand query and use it multiple times

 

[SHANEMAC51]

On my contact log table the agent cd and contact reason are lookup boxes (design view img 3)

you don't have a search by last name and agency - since you don't have any free fields

 

[June7]

I seldom need or use dynamic parameterized queries. I apply filter criteria to form or report.

 

[June7]

True. I developed a db at work with Access frontend and backend. The agency standard was Oracle and that would have meant coordinating with Oracle database manager located in another city. So, we stuck with Access to maintain local control. Oracle (or SQLServer) would have been overkill for our needs.