sql - MS Access - Query bringing in "new record" row -
i have query populating form , form allow data set edited. issue having query pulling last row used add new record. results in having row looks shows fields blank, leaves 1 field "null".
i played around query , able find workaround selecting "distinct" records, problem when select distinct, cannot edit data set. there other way around this?
i can upload example of database if needed. thanks!
edit: picture show issue: https://imgbomb.com/i/?ro1sp
Comments
Post a Comment