DataEntry

[BT24]

Hello
when i try to change the field so that I can change or add data in the properties box it will open the form and be completely blank. so the only way that the form will open with the boxs and the subform is if i have the dataentry set to "no"

thanks for the help
BT24

 

[LittleSmudge]

DataEntry means add NEW records

So with DataEntry set to YES you will never be able to see old records that have been saved in the past.

Setting DataEntry to NO does not prevent you from adding new records ( Setting 'Allow Additions' to No does that ).



'ope-that-'elps.

G LS

 

[BT24]

I See...so why wont the box let me choose what i want then?
thanks for the help
BT24

 

[LittleSmudge]

What BOX are you refering to ?

 

[BT24]

The combo box...sorry

 

[LittleSmudge]

Okay BT24 - from the top - Explain it again.

You have a Form.
Do you want this form opening in DataAdd mode or in Edit mode ?
What table is the form bound to ?

The combo box:
What field in the above table is the control bound to ?

What is the Row Source of the combo box ?


G LS

 

[BT24]

Sorry again..the form is opened in edit mode and it is bound to a query that looks up a Area and when you choose a area the query sorts the locations inside that area and shows them in the combo box. and that combo box is bound to another query that puts the locations in there. thats the row source.
i think thats what you wanted to know
Thanks for your help
BT24

 

[LittleSmudge]

I think you've answered it.

However
when you choose a area the query sorts the locations inside that area and shows them in the combo box

and

and that combo box is bound to another query that puts the locations in there

seem to be going two different places to do the same job.


So you choose an Area - what, via another combo box ?
Are the Form and the combo box bound to the same underlying tables ?

Ar, AR, AR
When you have chosen the area and the query has "put the locations in there" do you then REQUERY the combo box so that it knows to display the new RowSourse settings ???


G LS

 

[BT24]

what happens is that in the query in Criteria i have the Question "For Which Area?" and when the form is opened a msgbox opens and asks that question and you would fill in the answer, from there the query will sort it by that information and give you the locations from either area 1,2 or 3. the form is bound to the query which was made from a table that has the locations and the areas together.

thanks for the help, i hope that i have not been to vague
BT24