When I show my form I want the database to move to a specific record (currentrecord)
I have used this code after the database (in a data module dm) is opened in my onformshow event:
dm.mouldingstable.locate('id', currentrecord, []);
The problem is that while all other database-linked controls on the form show the correct record, the FMXLivegrid has not scrolled to select the correct row.
However, if I put the dm.mouldingstable.locate('id', currentrecord, []); code in a button.onclick event on the form it works as expected.
How do I get the FMXLivegrid to show the current record in the database?
This used to work with a TStringgrid but not with an FMXLivegrid