Hi
On my PO Form :
Currently I have a Combo Box : PONo_Combo
The following is the Row source
SELECT PO.PONo, PO.PODate, PO.POTypeID, PO.POType, PO.ID
I have a field called PODate on the form where the Control Source =
=[PONo_Combo].[column](1)
Everything works fine.
My question is as follows:
Is there another way to populate the form instead of going to every fields control source and stipulating the column number? My form will probably end up having about 30 fields and to try and remember each column number or having to keep checking the column number seems a bit inefficient and tedious. I will also end up having many forms where I would need to do the same thing with different info etc... These forms will also have around 30 fields each
I would assume there are a number of ways of doing this and would welcome knowing them all. Best way to learn and build up the knowledge base
Thank You.