Hi all, i'm having a weird problem with some data not appearing in the forms i created.
I created a form that shows information about a client, and the form has a button once clicked displays more detailed information.
The button is setup with the button wizard, and produces an embeded macro that opens the form and uses the following to retrieve the required data
="[clients.clients_id]=" & [clients_id]
It does this fine with some tables, but with others it just returns a blank form???
The tables with the data in are complete, so there is no missing fields.
The only thing that i can think of is that the 2 records that aren't displaying properly were created after the forms were created, while the 2 that are displaying correctly were entered into the tables before the forms were created??
Has anyone else come up against this before??
Thanks in advance
Andy