Value order

[faca]

Hello!



I have continuous form where i pick values (like invoice where you select products...) but every time i save this and come back order of picked values is messed up, how to fix that?

Thanks

[June7]

Order of what - the records on form? What order is showing? What order do you want? Apply sort criteria.

[faca]

Order of what - the records on form? What order is showing? What order do you want? Apply sort criteria.

order of records on form yes... i want them to be in same order as i select them

[June7]

Is there an autonumber field?

[faca]

Yes.. its combobox that auto-populates other fields

[June7]

That is not an autonumber type field in table.

I just did some testing. My form lists records in same order as entered.

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

[faca]

It's ok now.. i don't know what i did but it's working

tell me please is it possible that i somehow hide record in report so i can print report without that record?

Example:

Parts
4164253
EOF195
FT5407
DBREZ (name for working hours)

After i create service and choose parts i make WorkOrder and i print it.. but i would like to print parts only without DBREZ, is it possible?

I've attached database:
Attachment 38213

[June7]

If you don't want that record in report, then apply filter criteria in report RecordSource.

[faca]

If you don't want that record in report, then apply filter criteria in report RecordSource.

Thank you!! Working fine.


One more question:

I select parts in Service form and than click WorkOrder button .. form opens and it shows only 5 parts instead of 10 that were selected.. did i limit them somehow or what?

[June7]

I actually get error messages trying to add records to Service form, all textboxes referencing combobox show ERROR, button to open WorkOrder form errors. Very odd.

Subforms do not grow. Need the vertical scroll bar to see all records. Subreports do grow. Should build a report.

[faca]

I actually get error messages trying to add records to Service form, all textboxes referencing combobox show ERROR, button to open WorkOrder form errors. Very odd.

Subforms do not grow. Need the vertical scroll bar to see all records. Subreports do grow. Should build a report.

Yep, subreport solved the problem.. Thanks !!