Forms & Row Triggers

[AlPhilps]

Really need some help on this....

I'm fairly new to Access - what I have is this :-

I've got a continuous subform whose record source is a query (basically a table using parameters from some unbound combo boxes in the header). When ALL the combo boxes are populated the query runs, retrieving all relevant rows and allowing new rows to be inserted. So far this all works fine.

What I now need is a number of unbound text boxes in the subform to pull back reference information (from a different table) for each row retrieved. I can't work out how to do this - which triggers are relevant??
In ORACLE Forms I'd be using something like a Blockost-Query Trigger.

Cheers

 

[Darrylles]

Hi Al,

I think that the 'unbound' textboxes must be 'bound'.

In your sub-form query add the table(s) where you require info for the text-boxes. The table(s) must be related to the main sub-form table (obviously).

Bind the text-boxes.

You could also do this in code to make the text-boxes unbound, but will be more long-winded and it depends on your coding skills.

Regards,

Darrylles



"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[AlPhilps]

Thanks for replying Darryl.

Are you suggesting my subform needs to have a RecordSource of two tables? How do I do that?

Or are you suggesting my subform should be a query based upon two tables? (so my query is the RecordSource)
If the latter I can certainly do that but I'm left with a few problems...

Perhaps I should explain further :-

What I've got is a continuous SubForm based upon a Sales table. It also needs to display info from the Customer table (Customer Name & Account No) for each Sales Record retrieved. The link is the Customer_Id field.

What I need to be able to do is retrieve information from Sales into my subform (with reference info from Customers) and insert/update the Sales table ONLY based upon the Customer selected. I don't want to be able to insert new customers from here.

Rows available would be something like :-
C.CustomerName, C.CustAccountNo, S.SaleItem, S.SalePrice, S.SaleQuantity

Any ideas??
Cheers