Chime Error?

[bytreeide]

I upon trying to change the value of a combo box or text box I hear a chime and nothing happens.

Focus of the problem is FORM F4CBA

I have narrowed down cause of the problem to one of my Record Sources: Q4FinanceEntry.

If I don't include the listed Query then my combo boxes and text boxes can be edited. However, then I lose the control over a series of "locked" text boxes [Request ID, Request Type, Subject, Percent Usage, Units per Year, Replacement Cost, and Cost per batch]

I don't know what the cause of the problem is or why this happens.



I am open to suggestions for other methods to approach my problem also.

bytreeide

[June7]

Usually a form can do data entry/edit for only one table. Why does this form include 3 datasets in the RecordSource? Q4FinanceEntry is a query that has 4 datasets (one of which is another query). I expect the form's RecordSource is not editable when the query is included. Data entry form should not need such a complicated data source.

So what is purpose of form? Data entry for what table?

[bytreeide]

The purpose for the form is for someone in the manager level to get an overview of data while entering some pertinent information. So I want to be able to display, on this form a few noteworthy points of data from previous forms. It kinda sounds like something that should be handled in a report, but I had a request to leave some of the Controls "maliable" which doesn't really lend itself to being utilized as a Report does it?

Do you have any suggestions?

One solution that comes to me immediately would be for me to make space (add fields) in the TABLEs prior to this FORM. Then have those fields "trickle" down to the place that I want to use them. Let me attempt to visualize this:

Table 1
Field 1
Field 2
Field 3
Field 4

Table 2
Field 1
Field 1 From Table 1
Field 2
Field 3
Field 4

Table 3
Field 1
Field 1 From Table 1
Field 2
Field 3
Field 3 From Table 2
Field 4

Table 4
Field 1
Field 1 From Table 1
Field 1 From Table 3
Field 2
Field 3
Field 3 From Table 2
Field 3 From Table 3
Field 4

^Would this work?^

Then I would only have one query...

Still open to your suggestions.

bytreeide

[June7]

Cannot do data entry/edit through reports. And what I said about editing with form still holds.

I don't think trying to do all with one query is feasible - certainly not if query results in a non-editable dataset.

I suggest subforms or listboxes to display non-editable data.

[bytreeide]

I will try using subforms, I can't think how using a list box would work to both solve my problem and display the data in a clear and easy way.

[bytreeide]

June, back to what you initially said, "Usually a form can do data entry/edit for only one table" I want to point out that all of the data entry that comes from the FORM F4CBA is only going to TABLE T4CBA.

When using subforms, I get the following error: "The link you selected can't be used. This link was created based on relationships between source tables. To use this link, you must go back to the previous page and include the missing fields."

[June7]

I don't know what you attempted so don't know why you get that error. I've never encountered it.

I tried to understand the table Relationships and got lost in the spider web. Review: http://www.codeproject.com/Articles/...atabase-Design

[bytreeide]

So, what you are saying is that, the only one who can help me, is myself.

Would it help if I were to define the Join Properties of the relationships between the tables? The trouble is, that if I do this I don't know what the best way to define the relationship between T1Entry, T2FIN, T3ENG and T4CBA. I have redefined the relationships:

T1EntryID(One) to T2Entry(Many) ==> T1EntryID(One) to T2FinanceID(One)
T1EntryID(One) to T3Entry(Many) ==> T1EntryID(One) to T3EngineeringID(One)
T1EntryID(One) to T4Entry(Many) ==> T1EntryID(One) to T4cbaID(One)

My reasoning behind this is that for each Entry on TABLE 1 there is going to be one Entry on each of TABLEs 2, 3 and 4 that each correspond with the TABLE 1 Entry.

New DB attached

Any suggestions, questions, comments?

bytreeide

[June7]

Might help if I understood what this db is for and how the data entities relate but since I don't I am somewhat lost.

If the form is only for data entry/edit for table T4CBA, then set the RecordSource to that table and rebuild form using other methods to display related data. For instance, employee info can be displayed in textboxes with expressions that reference combobox column index (index begins with 0). Employee Name would be: =[Combo164].[Column](1) and ID Number would just be: =[Combo164]

[bytreeide]

The database is going to be used to track and vet the viability of new projects. A need is identified, it is then analyzed based on potential volume for exiting customers, then looked at from an engineering standpoint, finally analyzed financially. Then there are two other forms that will be to analyze the return on the investment based on the size of the investment.

To get back to your latest suggestion, i would like to turn your attention to F3Engnieering and the functionality of the two combo boxes "T1EntryID"(Combo54) and "Employee"(Combo46) (I need to change these names). These two work similar to how I would like the two combo boxes, "Entry ID#"(T4EntryID_Combo) and "Employee ID #" (Combo164 (Another name I should change)), perform from FCBA. So, I don't think that I need to reset the RecordSource to T4CBA. What I have tried is just removing the RowSource for "T4EntryID_Combo", then "Employee ID #" (Combo164) works correctly and I can change information in the "Tab Control"-portion.

Thanks for all the help so far.

bytreeide

[June7]

I still think should simplify the form RecordSource. When I did that controls bound to fields from related tables no longer included show #Error! I resolved the employee info errors with the described expressions.

None of the controls on the tab control were impacted.

Why is T4EmployeeID field in T4CBA linked to T1EntrySubject instead of T1EntryUser?

[bytreeide]

So when you say "Simplify the FORM RecordSource" you mean to set as only T4CBA and not have anything added. Then take both of the ComboBoxes (Entry ID and Employee ID) and make them each have a ROW SOURCE that is a QUERY. And have each of the combo boxes update the necessary controls (text boxes) using VBA code? If you mean something else then I would appreciate it very if you could clarify what you mean.

The Tab controls shouldn't be impacted as they are all "taken care of" using the TABLE T4CBA and VBA Code.

That link that you pointed out was a mistake, not intentional.

[June7]

I did not suggest VBA code for display of related employee info. I suggested expressions in textbox ControlSource.

What do you mean by 'taken care of'? Code does what with these controls?

If you build Relationships, make sure they are correct or will frustrate you when building queries.

[bytreeide]

Okay, thank you for the clarification on the simplification point.

What I meant with the Tab Control is that the first four tabs would be unaffected by any changes that take place as long as T4CBA remains in the RecordSource, because the controls that accept user entry are linked to the TABLE T4CBA. And then I have written expressions in the ControlSource for these. So those are "Taken care of." The last two tabs do not need any expressions, they are linked to the TABLE T4CBA, and the check boxes have VBA code (on click) behind them that make certain controls Visible = 'Yes' or Visible = 'No'. This part really wasn't important to the issue at hand. I probably didn't need to say that. But now you know a little bit more about what I did.

I will take your warning on relationships.

I will take a shot at the simplification and get back to you with the results.

Thanks

bytreeide

[June7]

Conditional Formatting can set textboxes and comboboxes enabled/disabled based on criteria. They will still be visible but 'greyed out' disabled.