trouble with the way my form opens 2

[Jimenda]

Hi,
When my ACCESS Db is first opened I have it display just my form without a window. My form has 8 combo boxes in which items are selected and then save to a table by clicking a submit button. My problem is that whenever I open my database my form displays as it should, but it already has values in each combo box, these values match the value of the top record (oldest) of the table I'm saving to. How can I get this table to open with no preselected values?

Thank You,

Jimenda

 

[formerTexan]

Jimenda,

Place the following line of code on the form's open event:

DoCmd.GoToRecord , , acNewRec

This will result in the form opening to a pending new record.

Cheers,
Bill

 

[TheAceMan1]

How are ya Jimenda . . . . .

Thats strange . . . When a form opens, if there's no intervening code, it [blue]goes to the first record in the rcordset[/blue] (not the last). So there's two ways this can happen:
[ol][li]Code is sending the focus to the last record. Something like . . .

[blue]DoCmd.GotoRecord, , acLast[/blue]

[/li]
[li]The [purple]RecordSource[/purple] of the form is based on a query where the [purple]PrimaryKey is sorted decending[/purple].[/li][/ol]

In any case [blue]formerTexan[/blue] has prescribed what you need for resolution . . .

See Ya! . . . . . .