default values in a form

[kmims44]

I am using a form for Data entry and I'm trying to figure out 1. Is there a way I can I can Display the last record entered next to a blank data entry form so the user can see what they already enetered? 2. is there a way to lookup a record and based on 3 field values to autopopulate another field. I have 3 fields "ContractName" "WBS" "Slin" as drop down menus, when the user selcts the Contract Name I want it to filter the SLIN so that only SLINs on that contract can be selected, when they select WBS I want it to lookup records that match SLIN, WBS, and ContractName and use the Date field which i then want the form field to autopopulate the "next Date" (>Date already entered+30days). Can these tasks be done?

[June7]

Maybe.

1. You don't want to use Continuous or Datasheet view of forms? If you want SingleRecord view side-by-side, not sure how well this will work. Form/Subform may be one option. Form and subform will have identical RecordSource and controls. Main form opens to last record and subform set to open only to new record. Another possibilty is unbound controls as the 'new' record data entry and use VBA code to save the entered values to a new record in table.

2. Sounds like dependent (cascading) comboboxes, review http://datapigtechnologies.com/flash...combobox2.html. Autopopulating the date field will require VBA code.

[kmims44]

ok so I got the comobo box situation worked out for evrything except the date. The form has an unbound combo box labeled BudgetDate what I want to see there is a drop down menu of Month, Year of each month in the date range of PeriodofPerformanceStartDate and PeriodOfPerformanceEndDate. I assumed I would have to have thse dates on the form as well so I put them on but I have them hidden. i have revied the date range query posts and I cannot seem to get mine to work at all????

[kmims44]

nevermind I figured it out...finally!

[kmims44]

OK I lied I guess I didnt figure it out and I have found another issue now that I have set up the combo boxes...its not linking to any table????? Any idea what the VBA code would be for the date issue?

[June7]

What do you mean not linking to any table? Data from comboboxes is not saved to table?

Not sure about the date issue. I don't know your data structure and form setup well enough. What date do you want to base the calculation on - the last record in table meeting the specified criteria?

If you want to provide file for analysis, follow instructions at bottom of my post.

[MBA80]

June7,

I used the link you gave for the video on the cascading combo boxes. I am not following the process of how to get the second boxes results to be tied to the first combo box selection. One other explanation I found shows the need to have all of the information to be used between the different combo boxes. Another site shows that a query is needed to generate the proper responses to the subsequent combo boxes. I am a bit confused as to how I need to work this issue.

My situation is a simple DB (one that you helped me with before). The connected combo boxes I would like to create are this:

1) User selects the area they work
2) User selects the type of work they are doing.

Pretty straight forward, except for the fact that all but one of the "areas they work" will need to show the same options in the second combo box. There is one area of the company that will need their own unique entries to appear for the second combo box. I can clean out my DB and send it if need be.

[June7]

The tutorial is quite explicit. I am rather lost in your description of issue and why you are having difficulty applying the described technique. Yes, if you want to provide file might be able to understand better.

How many areas and how many types are there?

[MBA80]

Sorry for the delay in response, work is crazy right now.

I am confused on what is needed for the combo boxes to pull their information to begin with. Is the upper box in the video just populated from a field in a table? Wouldn't the second box (based on the information put in the first box) need to be a query of some sort so that the query is rerun depending on what information is selected in the first box?

[June7]

Both comboboxes would have a RowSource that queries a table to provide a list of values. The second combobox would have criteria referencing the first combobox. The second combobox would be requeried by VBA code in the AfterUpdate event of the first combobox (or the GotFocus event of the second).

This is all demonstrated step-by-step in the video. However, if that one is not getting the point across, Google dependent comboboxes. There are other tutorials available.