Query Query

multiple possibilities, but too tired, listening  . . .

Why not use a Filter
MyInvoiceNumber.Value:=xxxxx;
MyInvoice.Filtered:=True;

And then show the invoice with the Data Aware Controls as Dbedit .... in the other form.

Application.CreateForm(TMyInvoiceForm, MyInvoiceForm);
MyInvoiceForm.ShowModal;

Best Regards.
Marcos.

Or add the property InvoiceNumber to your form and assign it before showing it.  Then, when you're back, you can validate it or follow the course of action you want.

T-Rex

it goes simpler, later, just waked up

back again, with a cup of coffee :-)

well, i would drop a datasource on your invoiceform and let point the dataset-property to the invoicetable of your mainform, thats all

meikl ;-)

Good Morning kretzschmar, and how's the coffee 4 u?

>and how's the coffee 4 u?
strong, as recommended ;-)

The spice must flow ;-)

kretzschmar,
I tried your suggestion and it works (If I use a DBGrid), but I want to use DBEdit components so I can arrange them properly on the form - when I do this I only get the first record.

They *are* pointing to the correct datasource.
What can be wrong??
-Freerider

>do this I only get the first record.
not really,
the form should display the current record,
which is selected in the childgrid of your mainform

if you want to scroll, within this form,
just place a tdbnavigator on the form,
and connect its datasource-property
to the datasource on the form

if needed, i could code a little sample,
and send it to you (mail-adress required)

hope this helps

meikl ;-)

kretzschmar
>not really,
I *do*!!!??

>the form should display the current record,
I have both the DBGrid and the DBEdit fields on the same form. The DBGrid shows the current record as expected.
They are pointing to the same Dataset - I've checked it a hundred times!
 
A sample would be great:
andrewKEEPYOURSPAMgreaney@snowboard.com

Thanks.

I mean DataSource.

one day later, early in the morning, with a cup of coffee :-))

sample in work

meikl ;-)

sample on the way ;-)

mailing failed :-(

validate your given mail adress

Sorry,

did you take out KEEPYOURSPAM ??

no, what to use instead?

where should i now send it instead?

OK,
can you send it to:

andrewgreaney@libero.it

Thanks.

kretzschmar,

I still haven't received your sample.
Did you manage to send it ok?

Freerider.

kretzschmar,

I still haven't received your sample.
Did you manage to send it ok?

Freerider.

>Did you manage to send it ok?
just now :-)

sorry, for delay

meikl ;-)

Thanks meikl,

I got it to work (using an Access database) - sort of. The only problem is when I open the invoice on a new form, I can't edit the data.

I need to check to see which Table I'm accessing, or do I need to set an option for editing somewhere?...

Freerider.

I eventually used the method suggested by alsantos , but want to split the points as meikl's sample was also very helpfull. How do I split points??

ask at community support for splitting points ;-)